/*
 Navicat MySQL Data Transfer

 Source Server         : chen
 Source Server Type    : MySQL
 Source Server Version : 100138
 Source Host           : localhost:3306
 Source Schema         : wy

 Target Server Type    : MySQL
 Target Server Version : 100138
 File Encoding         : 65001

 Date: 05/10/2019 15:25:11
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for wy_area
-- ----------------------------
DROP TABLE IF EXISTS `wy_area`;
CREATE TABLE `wy_area` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `parent_id` bigint(20) NOT NULL DEFAULT '0',
  `sort` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=321112 DEFAULT CHARSET=utf8 COMMENT='地区表';

-- ----------------------------
-- Records of wy_area
-- ----------------------------
BEGIN;
INSERT INTO `wy_area` VALUES (110000, '北京市', 0, 1);
INSERT INTO `wy_area` VALUES (110100, '北京市', 110000, 1);
INSERT INTO `wy_area` VALUES (110101, '东城区', 110100, 1);
INSERT INTO `wy_area` VALUES (110102, '西城区', 110100, 2);
INSERT INTO `wy_area` VALUES (110103, '崇文区', 110100, 3);
INSERT INTO `wy_area` VALUES (110104, '宣武区', 110100, 4);
INSERT INTO `wy_area` VALUES (110105, '朝阳区', 110100, 5);
INSERT INTO `wy_area` VALUES (110106, '丰台区', 110100, 6);
INSERT INTO `wy_area` VALUES (110107, '石景山区', 110100, 7);
INSERT INTO `wy_area` VALUES (110108, '海淀区', 110100, 8);
INSERT INTO `wy_area` VALUES (110109, '门头沟区', 110100, 9);
INSERT INTO `wy_area` VALUES (110111, '房山区', 110100, 10);
INSERT INTO `wy_area` VALUES (110112, '通州区', 110100, 11);
INSERT INTO `wy_area` VALUES (110113, '顺义区', 110100, 12);
INSERT INTO `wy_area` VALUES (110114, '昌平区', 110100, 13);
INSERT INTO `wy_area` VALUES (110115, '大兴区', 110100, 14);
INSERT INTO `wy_area` VALUES (110116, '怀柔区', 110100, 15);
INSERT INTO `wy_area` VALUES (110117, '平谷区', 110100, 16);
INSERT INTO `wy_area` VALUES (110200, '县', 110000, 2);
INSERT INTO `wy_area` VALUES (110228, '密云县', 110200, 1);
INSERT INTO `wy_area` VALUES (110229, '延庆县', 110200, 2);
INSERT INTO `wy_area` VALUES (120000, '天津市', 0, 2);
INSERT INTO `wy_area` VALUES (120100, '市辖区', 120000, 1);
INSERT INTO `wy_area` VALUES (120101, '和平区', 120100, 1);
INSERT INTO `wy_area` VALUES (120102, '河东区', 120100, 2);
INSERT INTO `wy_area` VALUES (120103, '河西区', 120100, 3);
INSERT INTO `wy_area` VALUES (120104, '南开区', 120100, 4);
INSERT INTO `wy_area` VALUES (120105, '河北区', 120100, 5);
INSERT INTO `wy_area` VALUES (120106, '红桥区', 120100, 6);
INSERT INTO `wy_area` VALUES (120107, '塘沽区', 120100, 7);
INSERT INTO `wy_area` VALUES (120108, '汉沽区', 120100, 8);
INSERT INTO `wy_area` VALUES (120109, '大港区', 120100, 9);
INSERT INTO `wy_area` VALUES (120110, '东丽区', 120100, 10);
INSERT INTO `wy_area` VALUES (120111, '西青区', 120100, 11);
INSERT INTO `wy_area` VALUES (120112, '津南区', 120100, 12);
INSERT INTO `wy_area` VALUES (120113, '北辰区', 120100, 13);
INSERT INTO `wy_area` VALUES (120114, '武清区', 120100, 14);
INSERT INTO `wy_area` VALUES (120115, '宝坻区', 120100, 15);
INSERT INTO `wy_area` VALUES (120200, '县', 120000, 2);
INSERT INTO `wy_area` VALUES (120221, '宁河县', 120200, 1);
INSERT INTO `wy_area` VALUES (120223, '静海县', 120200, 2);
INSERT INTO `wy_area` VALUES (120225, '蓟　县', 120200, 3);
INSERT INTO `wy_area` VALUES (130000, '河北省', 0, 3);
INSERT INTO `wy_area` VALUES (130100, '石家庄市', 130000, 1);
INSERT INTO `wy_area` VALUES (130101, '市辖区', 130100, 1);
INSERT INTO `wy_area` VALUES (130102, '长安区', 130100, 2);
INSERT INTO `wy_area` VALUES (130103, '桥东区', 130100, 3);
INSERT INTO `wy_area` VALUES (130104, '桥西区', 130100, 4);
INSERT INTO `wy_area` VALUES (130105, '新华区', 130100, 5);
INSERT INTO `wy_area` VALUES (130107, '井陉矿区', 130100, 6);
INSERT INTO `wy_area` VALUES (130108, '裕华区', 130100, 7);
INSERT INTO `wy_area` VALUES (130121, '井陉县', 130100, 8);
INSERT INTO `wy_area` VALUES (130123, '正定县', 130100, 9);
INSERT INTO `wy_area` VALUES (130124, '栾城县', 130100, 10);
INSERT INTO `wy_area` VALUES (130125, '行唐县', 130100, 11);
INSERT INTO `wy_area` VALUES (130126, '灵寿县', 130100, 12);
INSERT INTO `wy_area` VALUES (130127, '高邑县', 130100, 13);
INSERT INTO `wy_area` VALUES (130128, '深泽县', 130100, 14);
INSERT INTO `wy_area` VALUES (130129, '赞皇县', 130100, 15);
INSERT INTO `wy_area` VALUES (130130, '无极县', 130100, 16);
INSERT INTO `wy_area` VALUES (130131, '平山县', 130100, 17);
INSERT INTO `wy_area` VALUES (130132, '元氏县', 130100, 18);
INSERT INTO `wy_area` VALUES (130133, '赵　县', 130100, 19);
INSERT INTO `wy_area` VALUES (130181, '辛集市', 130100, 20);
INSERT INTO `wy_area` VALUES (130182, '藁城市', 130100, 21);
INSERT INTO `wy_area` VALUES (130183, '晋州市', 130100, 22);
INSERT INTO `wy_area` VALUES (130184, '新乐市', 130100, 23);
INSERT INTO `wy_area` VALUES (130185, '鹿泉市', 130100, 24);
INSERT INTO `wy_area` VALUES (130200, '唐山市', 130000, 2);
INSERT INTO `wy_area` VALUES (130201, '市辖区', 130200, 1);
INSERT INTO `wy_area` VALUES (130202, '路南区', 130200, 2);
INSERT INTO `wy_area` VALUES (130203, '路北区', 130200, 3);
INSERT INTO `wy_area` VALUES (130204, '古冶区', 130200, 4);
INSERT INTO `wy_area` VALUES (130205, '开平区', 130200, 5);
INSERT INTO `wy_area` VALUES (130207, '丰南区', 130200, 6);
INSERT INTO `wy_area` VALUES (130208, '丰润区', 130200, 7);
INSERT INTO `wy_area` VALUES (130223, '滦　县', 130200, 8);
INSERT INTO `wy_area` VALUES (130224, '滦南县', 130200, 9);
INSERT INTO `wy_area` VALUES (130225, '乐亭县', 130200, 10);
INSERT INTO `wy_area` VALUES (130227, '迁西县', 130200, 11);
INSERT INTO `wy_area` VALUES (130229, '玉田县', 130200, 12);
INSERT INTO `wy_area` VALUES (130230, '唐海县', 130200, 13);
INSERT INTO `wy_area` VALUES (130281, '遵化市', 130200, 14);
INSERT INTO `wy_area` VALUES (130283, '迁安市', 130200, 15);
INSERT INTO `wy_area` VALUES (130300, '秦皇岛市', 130000, 3);
INSERT INTO `wy_area` VALUES (130301, '市辖区', 130300, 1);
INSERT INTO `wy_area` VALUES (130302, '海港区', 130300, 2);
INSERT INTO `wy_area` VALUES (130303, '山海关区', 130300, 3);
INSERT INTO `wy_area` VALUES (130304, '北戴河区', 130300, 4);
INSERT INTO `wy_area` VALUES (130321, '青龙满族自治县', 130300, 5);
INSERT INTO `wy_area` VALUES (130322, '昌黎县', 130300, 6);
INSERT INTO `wy_area` VALUES (130323, '抚宁县', 130300, 7);
INSERT INTO `wy_area` VALUES (130324, '卢龙县', 130300, 8);
INSERT INTO `wy_area` VALUES (130400, '邯郸市', 130000, 4);
INSERT INTO `wy_area` VALUES (130401, '市辖区', 130400, 1);
INSERT INTO `wy_area` VALUES (130402, '邯山区', 130400, 2);
INSERT INTO `wy_area` VALUES (130403, '丛台区', 130400, 3);
INSERT INTO `wy_area` VALUES (130404, '复兴区', 130400, 4);
INSERT INTO `wy_area` VALUES (130406, '峰峰矿区', 130400, 5);
INSERT INTO `wy_area` VALUES (130421, '邯郸县', 130400, 6);
INSERT INTO `wy_area` VALUES (130423, '临漳县', 130400, 7);
INSERT INTO `wy_area` VALUES (130424, '成安县', 130400, 8);
INSERT INTO `wy_area` VALUES (130425, '大名县', 130400, 9);
INSERT INTO `wy_area` VALUES (130426, '涉　县', 130400, 10);
INSERT INTO `wy_area` VALUES (130427, '磁　县', 130400, 11);
INSERT INTO `wy_area` VALUES (130428, '肥乡县', 130400, 12);
INSERT INTO `wy_area` VALUES (130429, '永年县', 130400, 13);
INSERT INTO `wy_area` VALUES (130430, '邱　县', 130400, 14);
INSERT INTO `wy_area` VALUES (130431, '鸡泽县', 130400, 15);
INSERT INTO `wy_area` VALUES (130432, '广平县', 130400, 16);
INSERT INTO `wy_area` VALUES (130433, '馆陶县', 130400, 17);
INSERT INTO `wy_area` VALUES (130434, '魏　县', 130400, 18);
INSERT INTO `wy_area` VALUES (130435, '曲周县', 130400, 19);
INSERT INTO `wy_area` VALUES (130481, '武安市', 130400, 20);
INSERT INTO `wy_area` VALUES (130500, '邢台市', 130000, 5);
INSERT INTO `wy_area` VALUES (130501, '市辖区', 130500, 1);
INSERT INTO `wy_area` VALUES (130502, '桥东区', 130500, 2);
INSERT INTO `wy_area` VALUES (130503, '桥西区', 130500, 3);
INSERT INTO `wy_area` VALUES (130521, '邢台县', 130500, 4);
INSERT INTO `wy_area` VALUES (130522, '临城县', 130500, 5);
INSERT INTO `wy_area` VALUES (130523, '内丘县', 130500, 6);
INSERT INTO `wy_area` VALUES (130524, '柏乡县', 130500, 7);
INSERT INTO `wy_area` VALUES (130525, '隆尧县', 130500, 8);
INSERT INTO `wy_area` VALUES (130526, '任　县', 130500, 9);
INSERT INTO `wy_area` VALUES (130527, '南和县', 130500, 10);
INSERT INTO `wy_area` VALUES (130528, '宁晋县', 130500, 11);
INSERT INTO `wy_area` VALUES (130529, '巨鹿县', 130500, 12);
INSERT INTO `wy_area` VALUES (130530, '新河县', 130500, 13);
INSERT INTO `wy_area` VALUES (130531, '广宗县', 130500, 14);
INSERT INTO `wy_area` VALUES (130532, '平乡县', 130500, 15);
INSERT INTO `wy_area` VALUES (130533, '威　县', 130500, 16);
INSERT INTO `wy_area` VALUES (130534, '清河县', 130500, 17);
INSERT INTO `wy_area` VALUES (130535, '临西县', 130500, 18);
INSERT INTO `wy_area` VALUES (130581, '南宫市', 130500, 19);
INSERT INTO `wy_area` VALUES (130582, '沙河市', 130500, 20);
INSERT INTO `wy_area` VALUES (130600, '保定市', 130000, 6);
INSERT INTO `wy_area` VALUES (130601, '市辖区', 130600, 1);
INSERT INTO `wy_area` VALUES (130602, '新市区', 130600, 2);
INSERT INTO `wy_area` VALUES (130603, '北市区', 130600, 3);
INSERT INTO `wy_area` VALUES (130604, '南市区', 130600, 4);
INSERT INTO `wy_area` VALUES (130621, '满城县', 130600, 5);
INSERT INTO `wy_area` VALUES (130622, '清苑县', 130600, 6);
INSERT INTO `wy_area` VALUES (130623, '涞水县', 130600, 7);
INSERT INTO `wy_area` VALUES (130624, '阜平县', 130600, 8);
INSERT INTO `wy_area` VALUES (130625, '徐水县', 130600, 9);
INSERT INTO `wy_area` VALUES (130626, '定兴县', 130600, 10);
INSERT INTO `wy_area` VALUES (130627, '唐　县', 130600, 11);
INSERT INTO `wy_area` VALUES (130628, '高阳县', 130600, 12);
INSERT INTO `wy_area` VALUES (130629, '容城县', 130600, 13);
INSERT INTO `wy_area` VALUES (130630, '涞源县', 130600, 14);
INSERT INTO `wy_area` VALUES (130631, '望都县', 130600, 15);
INSERT INTO `wy_area` VALUES (130632, '安新县', 130600, 16);
INSERT INTO `wy_area` VALUES (130633, '易　县', 130600, 17);
INSERT INTO `wy_area` VALUES (130634, '曲阳县', 130600, 18);
INSERT INTO `wy_area` VALUES (130635, '蠡　县', 130600, 19);
INSERT INTO `wy_area` VALUES (130636, '顺平县', 130600, 20);
INSERT INTO `wy_area` VALUES (130637, '博野县', 130600, 21);
INSERT INTO `wy_area` VALUES (130638, '雄　县', 130600, 22);
INSERT INTO `wy_area` VALUES (130681, '涿州市', 130600, 23);
INSERT INTO `wy_area` VALUES (130682, '定州市', 130600, 24);
INSERT INTO `wy_area` VALUES (130683, '安国市', 130600, 25);
INSERT INTO `wy_area` VALUES (130684, '高碑店市', 130600, 26);
INSERT INTO `wy_area` VALUES (130700, '张家口市', 130000, 7);
INSERT INTO `wy_area` VALUES (130701, '市辖区', 130700, 1);
INSERT INTO `wy_area` VALUES (130702, '桥东区', 130700, 2);
INSERT INTO `wy_area` VALUES (130703, '桥西区', 130700, 3);
INSERT INTO `wy_area` VALUES (130705, '宣化区', 130700, 4);
INSERT INTO `wy_area` VALUES (130706, '下花园区', 130700, 5);
INSERT INTO `wy_area` VALUES (130721, '宣化县', 130700, 6);
INSERT INTO `wy_area` VALUES (130722, '张北县', 130700, 7);
INSERT INTO `wy_area` VALUES (130723, '康保县', 130700, 8);
INSERT INTO `wy_area` VALUES (130724, '沽源县', 130700, 9);
INSERT INTO `wy_area` VALUES (130725, '尚义县', 130700, 10);
INSERT INTO `wy_area` VALUES (130726, '蔚　县', 130700, 11);
INSERT INTO `wy_area` VALUES (130727, '阳原县', 130700, 12);
INSERT INTO `wy_area` VALUES (130728, '怀安县', 130700, 13);
INSERT INTO `wy_area` VALUES (130729, '万全县', 130700, 14);
INSERT INTO `wy_area` VALUES (130730, '怀来县', 130700, 15);
INSERT INTO `wy_area` VALUES (130731, '涿鹿县', 130700, 16);
INSERT INTO `wy_area` VALUES (130732, '赤城县', 130700, 17);
INSERT INTO `wy_area` VALUES (130733, '崇礼县', 130700, 18);
INSERT INTO `wy_area` VALUES (130800, '承德市', 130000, 8);
INSERT INTO `wy_area` VALUES (130801, '市辖区', 130800, 1);
INSERT INTO `wy_area` VALUES (130802, '双桥区', 130800, 2);
INSERT INTO `wy_area` VALUES (130803, '双滦区', 130800, 3);
INSERT INTO `wy_area` VALUES (130804, '鹰手营子矿区', 130800, 4);
INSERT INTO `wy_area` VALUES (130821, '承德县', 130800, 5);
INSERT INTO `wy_area` VALUES (130822, '兴隆县', 130800, 6);
INSERT INTO `wy_area` VALUES (130823, '平泉县', 130800, 7);
INSERT INTO `wy_area` VALUES (130824, '滦平县', 130800, 8);
INSERT INTO `wy_area` VALUES (130825, '隆化县', 130800, 9);
INSERT INTO `wy_area` VALUES (130826, '丰宁满族自治县', 130800, 10);
INSERT INTO `wy_area` VALUES (130827, '宽城满族自治县', 130800, 11);
INSERT INTO `wy_area` VALUES (130828, '围场满族蒙古族自治县', 130800, 12);
INSERT INTO `wy_area` VALUES (130900, '沧州市', 130000, 9);
INSERT INTO `wy_area` VALUES (130901, '市辖区', 130900, 1);
INSERT INTO `wy_area` VALUES (130902, '新华区', 130900, 2);
INSERT INTO `wy_area` VALUES (130903, '运河区', 130900, 3);
INSERT INTO `wy_area` VALUES (130921, '沧　县', 130900, 4);
INSERT INTO `wy_area` VALUES (130922, '青　县', 130900, 5);
INSERT INTO `wy_area` VALUES (130923, '东光县', 130900, 6);
INSERT INTO `wy_area` VALUES (130924, '海兴县', 130900, 7);
INSERT INTO `wy_area` VALUES (130925, '盐山县', 130900, 8);
INSERT INTO `wy_area` VALUES (130926, '肃宁县', 130900, 9);
INSERT INTO `wy_area` VALUES (130927, '南皮县', 130900, 10);
INSERT INTO `wy_area` VALUES (130928, '吴桥县', 130900, 11);
INSERT INTO `wy_area` VALUES (130929, '献　县', 130900, 12);
INSERT INTO `wy_area` VALUES (130930, '孟村回族自治县', 130900, 13);
INSERT INTO `wy_area` VALUES (130981, '泊头市', 130900, 14);
INSERT INTO `wy_area` VALUES (130982, '任丘市', 130900, 15);
INSERT INTO `wy_area` VALUES (130983, '黄骅市', 130900, 16);
INSERT INTO `wy_area` VALUES (130984, '河间市', 130900, 17);
INSERT INTO `wy_area` VALUES (131000, '廊坊市', 130000, 10);
INSERT INTO `wy_area` VALUES (131001, '市辖区', 131000, 1);
INSERT INTO `wy_area` VALUES (131002, '安次区', 131000, 2);
INSERT INTO `wy_area` VALUES (131003, '广阳区', 131000, 3);
INSERT INTO `wy_area` VALUES (131022, '固安县', 131000, 4);
INSERT INTO `wy_area` VALUES (131023, '永清县', 131000, 5);
INSERT INTO `wy_area` VALUES (131024, '香河县', 131000, 6);
INSERT INTO `wy_area` VALUES (131025, '大城县', 131000, 7);
INSERT INTO `wy_area` VALUES (131026, '文安县', 131000, 8);
INSERT INTO `wy_area` VALUES (131028, '大厂回族自治县', 131000, 9);
INSERT INTO `wy_area` VALUES (131081, '霸州市', 131000, 10);
INSERT INTO `wy_area` VALUES (131082, '三河市', 131000, 11);
INSERT INTO `wy_area` VALUES (131100, '衡水市', 130000, 11);
INSERT INTO `wy_area` VALUES (131101, '市辖区', 131100, 1);
INSERT INTO `wy_area` VALUES (131102, '桃城区', 131100, 2);
INSERT INTO `wy_area` VALUES (131121, '枣强县', 131100, 3);
INSERT INTO `wy_area` VALUES (131122, '武邑县', 131100, 4);
INSERT INTO `wy_area` VALUES (131123, '武强县', 131100, 5);
INSERT INTO `wy_area` VALUES (131124, '饶阳县', 131100, 6);
INSERT INTO `wy_area` VALUES (131125, '安平县', 131100, 7);
INSERT INTO `wy_area` VALUES (131126, '故城县', 131100, 8);
INSERT INTO `wy_area` VALUES (131127, '景　县', 131100, 9);
INSERT INTO `wy_area` VALUES (131128, '阜城县', 131100, 10);
INSERT INTO `wy_area` VALUES (131181, '冀州市', 131100, 11);
INSERT INTO `wy_area` VALUES (131182, '深州市', 131100, 12);
INSERT INTO `wy_area` VALUES (140000, '山西省', 0, 4);
INSERT INTO `wy_area` VALUES (140100, '太原市', 140000, 1);
INSERT INTO `wy_area` VALUES (140101, '市辖区', 140100, 1);
INSERT INTO `wy_area` VALUES (140105, '小店区', 140100, 2);
INSERT INTO `wy_area` VALUES (140106, '迎泽区', 140100, 3);
INSERT INTO `wy_area` VALUES (140107, '杏花岭区', 140100, 4);
INSERT INTO `wy_area` VALUES (140108, '尖草坪区', 140100, 5);
INSERT INTO `wy_area` VALUES (140109, '万柏林区', 140100, 6);
INSERT INTO `wy_area` VALUES (140110, '晋源区', 140100, 7);
INSERT INTO `wy_area` VALUES (140121, '清徐县', 140100, 8);
INSERT INTO `wy_area` VALUES (140122, '阳曲县', 140100, 9);
INSERT INTO `wy_area` VALUES (140123, '娄烦县', 140100, 10);
INSERT INTO `wy_area` VALUES (140181, '古交市', 140100, 11);
INSERT INTO `wy_area` VALUES (140200, '大同市', 140000, 2);
INSERT INTO `wy_area` VALUES (140201, '市辖区', 140200, 1);
INSERT INTO `wy_area` VALUES (140202, '城　区', 140200, 2);
INSERT INTO `wy_area` VALUES (140203, '矿　区', 140200, 3);
INSERT INTO `wy_area` VALUES (140211, '南郊区', 140200, 4);
INSERT INTO `wy_area` VALUES (140212, '新荣区', 140200, 5);
INSERT INTO `wy_area` VALUES (140221, '阳高县', 140200, 6);
INSERT INTO `wy_area` VALUES (140222, '天镇县', 140200, 7);
INSERT INTO `wy_area` VALUES (140223, '广灵县', 140200, 8);
INSERT INTO `wy_area` VALUES (140224, '灵丘县', 140200, 9);
INSERT INTO `wy_area` VALUES (140225, '浑源县', 140200, 10);
INSERT INTO `wy_area` VALUES (140226, '左云县', 140200, 11);
INSERT INTO `wy_area` VALUES (140227, '大同县', 140200, 12);
INSERT INTO `wy_area` VALUES (140300, '阳泉市', 140000, 3);
INSERT INTO `wy_area` VALUES (140301, '市辖区', 140300, 1);
INSERT INTO `wy_area` VALUES (140302, '城　区', 140300, 2);
INSERT INTO `wy_area` VALUES (140303, '矿　区', 140300, 3);
INSERT INTO `wy_area` VALUES (140311, '郊　区', 140300, 4);
INSERT INTO `wy_area` VALUES (140321, '平定县', 140300, 5);
INSERT INTO `wy_area` VALUES (140322, '盂　县', 140300, 6);
INSERT INTO `wy_area` VALUES (140400, '长治市', 140000, 4);
INSERT INTO `wy_area` VALUES (140401, '市辖区', 140400, 1);
INSERT INTO `wy_area` VALUES (140402, '城　区', 140400, 2);
INSERT INTO `wy_area` VALUES (140411, '郊　区', 140400, 3);
INSERT INTO `wy_area` VALUES (140421, '长治县', 140400, 4);
INSERT INTO `wy_area` VALUES (140423, '襄垣县', 140400, 5);
INSERT INTO `wy_area` VALUES (140424, '屯留县', 140400, 6);
INSERT INTO `wy_area` VALUES (140425, '平顺县', 140400, 7);
INSERT INTO `wy_area` VALUES (140426, '黎城县', 140400, 8);
INSERT INTO `wy_area` VALUES (140427, '壶关县', 140400, 9);
INSERT INTO `wy_area` VALUES (140428, '长子县', 140400, 10);
INSERT INTO `wy_area` VALUES (140429, '武乡县', 140400, 11);
INSERT INTO `wy_area` VALUES (140430, '沁　县', 140400, 12);
INSERT INTO `wy_area` VALUES (140431, '沁源县', 140400, 13);
INSERT INTO `wy_area` VALUES (140481, '潞城市', 140400, 14);
INSERT INTO `wy_area` VALUES (140500, '晋城市', 140000, 5);
INSERT INTO `wy_area` VALUES (140501, '市辖区', 140500, 1);
INSERT INTO `wy_area` VALUES (140502, '城　区', 140500, 2);
INSERT INTO `wy_area` VALUES (140521, '沁水县', 140500, 3);
INSERT INTO `wy_area` VALUES (140522, '阳城县', 140500, 4);
INSERT INTO `wy_area` VALUES (140524, '陵川县', 140500, 5);
INSERT INTO `wy_area` VALUES (140525, '泽州县', 140500, 6);
INSERT INTO `wy_area` VALUES (140581, '高平市', 140500, 7);
INSERT INTO `wy_area` VALUES (140600, '朔州市', 140000, 6);
INSERT INTO `wy_area` VALUES (140601, '市辖区', 140600, 1);
INSERT INTO `wy_area` VALUES (140602, '朔城区', 140600, 2);
INSERT INTO `wy_area` VALUES (140603, '平鲁区', 140600, 3);
INSERT INTO `wy_area` VALUES (140621, '山阴县', 140600, 4);
INSERT INTO `wy_area` VALUES (140622, '应　县', 140600, 5);
INSERT INTO `wy_area` VALUES (140623, '右玉县', 140600, 6);
INSERT INTO `wy_area` VALUES (140624, '怀仁县', 140600, 7);
INSERT INTO `wy_area` VALUES (140700, '晋中市', 140000, 7);
INSERT INTO `wy_area` VALUES (140701, '市辖区', 140700, 1);
INSERT INTO `wy_area` VALUES (140702, '榆次区', 140700, 2);
INSERT INTO `wy_area` VALUES (140721, '榆社县', 140700, 3);
INSERT INTO `wy_area` VALUES (140722, '左权县', 140700, 4);
INSERT INTO `wy_area` VALUES (140723, '和顺县', 140700, 5);
INSERT INTO `wy_area` VALUES (140724, '昔阳县', 140700, 6);
INSERT INTO `wy_area` VALUES (140725, '寿阳县', 140700, 7);
INSERT INTO `wy_area` VALUES (140726, '太谷县', 140700, 8);
INSERT INTO `wy_area` VALUES (140727, '祁　县', 140700, 9);
INSERT INTO `wy_area` VALUES (140728, '平遥县', 140700, 10);
INSERT INTO `wy_area` VALUES (140729, '灵石县', 140700, 11);
INSERT INTO `wy_area` VALUES (140781, '介休市', 140700, 12);
INSERT INTO `wy_area` VALUES (140800, '运城市', 140000, 8);
INSERT INTO `wy_area` VALUES (140801, '市辖区', 140800, 1);
INSERT INTO `wy_area` VALUES (140802, '盐湖区', 140800, 2);
INSERT INTO `wy_area` VALUES (140821, '临猗县', 140800, 3);
INSERT INTO `wy_area` VALUES (140822, '万荣县', 140800, 4);
INSERT INTO `wy_area` VALUES (140823, '闻喜县', 140800, 5);
INSERT INTO `wy_area` VALUES (140824, '稷山县', 140800, 6);
INSERT INTO `wy_area` VALUES (140825, '新绛县', 140800, 7);
INSERT INTO `wy_area` VALUES (140826, '绛　县', 140800, 8);
INSERT INTO `wy_area` VALUES (140827, '垣曲县', 140800, 9);
INSERT INTO `wy_area` VALUES (140828, '夏　县', 140800, 10);
INSERT INTO `wy_area` VALUES (140829, '平陆县', 140800, 11);
INSERT INTO `wy_area` VALUES (140830, '芮城县', 140800, 12);
INSERT INTO `wy_area` VALUES (140881, '永济市', 140800, 13);
INSERT INTO `wy_area` VALUES (140882, '河津市', 140800, 14);
INSERT INTO `wy_area` VALUES (140900, '忻州市', 140000, 9);
INSERT INTO `wy_area` VALUES (140901, '市辖区', 140900, 1);
INSERT INTO `wy_area` VALUES (140902, '忻府区', 140900, 2);
INSERT INTO `wy_area` VALUES (140921, '定襄县', 140900, 3);
INSERT INTO `wy_area` VALUES (140922, '五台县', 140900, 4);
INSERT INTO `wy_area` VALUES (140923, '代　县', 140900, 5);
INSERT INTO `wy_area` VALUES (140924, '繁峙县', 140900, 6);
INSERT INTO `wy_area` VALUES (140925, '宁武县', 140900, 7);
INSERT INTO `wy_area` VALUES (140926, '静乐县', 140900, 8);
INSERT INTO `wy_area` VALUES (140927, '神池县', 140900, 9);
INSERT INTO `wy_area` VALUES (140928, '五寨县', 140900, 10);
INSERT INTO `wy_area` VALUES (140929, '岢岚县', 140900, 11);
INSERT INTO `wy_area` VALUES (140930, '河曲县', 140900, 12);
INSERT INTO `wy_area` VALUES (140931, '保德县', 140900, 13);
INSERT INTO `wy_area` VALUES (140932, '偏关县', 140900, 14);
INSERT INTO `wy_area` VALUES (140981, '原平市', 140900, 15);
INSERT INTO `wy_area` VALUES (141000, '临汾市', 140000, 10);
INSERT INTO `wy_area` VALUES (141001, '市辖区', 141000, 1);
INSERT INTO `wy_area` VALUES (141002, '尧都区', 141000, 2);
INSERT INTO `wy_area` VALUES (141021, '曲沃县', 141000, 3);
INSERT INTO `wy_area` VALUES (141022, '翼城县', 141000, 4);
INSERT INTO `wy_area` VALUES (141023, '襄汾县', 141000, 5);
INSERT INTO `wy_area` VALUES (141024, '洪洞县', 141000, 6);
INSERT INTO `wy_area` VALUES (141025, '古　县', 141000, 7);
INSERT INTO `wy_area` VALUES (141026, '安泽县', 141000, 8);
INSERT INTO `wy_area` VALUES (141027, '浮山县', 141000, 9);
INSERT INTO `wy_area` VALUES (141028, '吉　县', 141000, 10);
INSERT INTO `wy_area` VALUES (141029, '乡宁县', 141000, 11);
INSERT INTO `wy_area` VALUES (141030, '大宁县', 141000, 12);
INSERT INTO `wy_area` VALUES (141031, '隰　县', 141000, 13);
INSERT INTO `wy_area` VALUES (141032, '永和县', 141000, 14);
INSERT INTO `wy_area` VALUES (141033, '蒲　县', 141000, 15);
INSERT INTO `wy_area` VALUES (141034, '汾西县', 141000, 16);
INSERT INTO `wy_area` VALUES (141081, '侯马市', 141000, 17);
INSERT INTO `wy_area` VALUES (141082, '霍州市', 141000, 18);
INSERT INTO `wy_area` VALUES (141100, '吕梁市', 140000, 11);
INSERT INTO `wy_area` VALUES (141101, '市辖区', 141100, 1);
INSERT INTO `wy_area` VALUES (141102, '离石区', 141100, 2);
INSERT INTO `wy_area` VALUES (141121, '文水县', 141100, 3);
INSERT INTO `wy_area` VALUES (141122, '交城县', 141100, 4);
INSERT INTO `wy_area` VALUES (141123, '兴　县', 141100, 5);
INSERT INTO `wy_area` VALUES (141124, '临　县', 141100, 6);
INSERT INTO `wy_area` VALUES (141125, '柳林县', 141100, 7);
INSERT INTO `wy_area` VALUES (141126, '石楼县', 141100, 8);
INSERT INTO `wy_area` VALUES (141127, '岚　县', 141100, 9);
INSERT INTO `wy_area` VALUES (141128, '方山县', 141100, 10);
INSERT INTO `wy_area` VALUES (141129, '中阳县', 141100, 11);
INSERT INTO `wy_area` VALUES (141130, '交口县', 141100, 12);
INSERT INTO `wy_area` VALUES (141181, '孝义市', 141100, 13);
INSERT INTO `wy_area` VALUES (141182, '汾阳市', 141100, 14);
INSERT INTO `wy_area` VALUES (150000, '内蒙古', 0, 5);
INSERT INTO `wy_area` VALUES (150100, '呼和浩特市', 150000, 1);
INSERT INTO `wy_area` VALUES (150101, '市辖区', 150100, 1);
INSERT INTO `wy_area` VALUES (150102, '新城区', 150100, 2);
INSERT INTO `wy_area` VALUES (150103, '回民区', 150100, 3);
INSERT INTO `wy_area` VALUES (150104, '玉泉区', 150100, 4);
INSERT INTO `wy_area` VALUES (150105, '赛罕区', 150100, 5);
INSERT INTO `wy_area` VALUES (150121, '土默特左旗', 150100, 6);
INSERT INTO `wy_area` VALUES (150122, '托克托县', 150100, 7);
INSERT INTO `wy_area` VALUES (150123, '和林格尔县', 150100, 8);
INSERT INTO `wy_area` VALUES (150124, '清水河县', 150100, 9);
INSERT INTO `wy_area` VALUES (150125, '武川县', 150100, 10);
INSERT INTO `wy_area` VALUES (150200, '包头市', 150000, 2);
INSERT INTO `wy_area` VALUES (150201, '市辖区', 150200, 1);
INSERT INTO `wy_area` VALUES (150202, '东河区', 150200, 2);
INSERT INTO `wy_area` VALUES (150203, '昆都仑区', 150200, 3);
INSERT INTO `wy_area` VALUES (150204, '青山区', 150200, 4);
INSERT INTO `wy_area` VALUES (150205, '石拐区', 150200, 5);
INSERT INTO `wy_area` VALUES (150206, '白云矿区', 150200, 6);
INSERT INTO `wy_area` VALUES (150207, '九原区', 150200, 7);
INSERT INTO `wy_area` VALUES (150221, '土默特右旗', 150200, 8);
INSERT INTO `wy_area` VALUES (150222, '固阳县', 150200, 9);
INSERT INTO `wy_area` VALUES (150223, '达尔罕茂明安联合旗', 150200, 10);
INSERT INTO `wy_area` VALUES (150300, '乌海市', 150000, 3);
INSERT INTO `wy_area` VALUES (150301, '市辖区', 150300, 1);
INSERT INTO `wy_area` VALUES (150302, '海勃湾区', 150300, 2);
INSERT INTO `wy_area` VALUES (150303, '海南区', 150300, 3);
INSERT INTO `wy_area` VALUES (150304, '乌达区', 150300, 4);
INSERT INTO `wy_area` VALUES (150400, '赤峰市', 150000, 4);
INSERT INTO `wy_area` VALUES (150401, '市辖区', 150400, 1);
INSERT INTO `wy_area` VALUES (150402, '红山区', 150400, 2);
INSERT INTO `wy_area` VALUES (150403, '元宝山区', 150400, 3);
INSERT INTO `wy_area` VALUES (150404, '松山区', 150400, 4);
INSERT INTO `wy_area` VALUES (150421, '阿鲁科尔沁旗', 150400, 5);
INSERT INTO `wy_area` VALUES (150422, '巴林左旗', 150400, 6);
INSERT INTO `wy_area` VALUES (150423, '巴林右旗', 150400, 7);
INSERT INTO `wy_area` VALUES (150424, '林西县', 150400, 8);
INSERT INTO `wy_area` VALUES (150425, '克什克腾旗', 150400, 9);
INSERT INTO `wy_area` VALUES (150426, '翁牛特旗', 150400, 10);
INSERT INTO `wy_area` VALUES (150428, '喀喇沁旗', 150400, 11);
INSERT INTO `wy_area` VALUES (150429, '宁城县', 150400, 12);
INSERT INTO `wy_area` VALUES (150430, '敖汉旗', 150400, 13);
INSERT INTO `wy_area` VALUES (150500, '通辽市', 150000, 5);
INSERT INTO `wy_area` VALUES (150501, '市辖区', 150500, 1);
INSERT INTO `wy_area` VALUES (150502, '科尔沁区', 150500, 2);
INSERT INTO `wy_area` VALUES (150521, '科尔沁左翼中旗', 150500, 3);
INSERT INTO `wy_area` VALUES (150522, '科尔沁左翼后旗', 150500, 4);
INSERT INTO `wy_area` VALUES (150523, '开鲁县', 150500, 5);
INSERT INTO `wy_area` VALUES (150524, '库伦旗', 150500, 6);
INSERT INTO `wy_area` VALUES (150525, '奈曼旗', 150500, 7);
INSERT INTO `wy_area` VALUES (150526, '扎鲁特旗', 150500, 8);
INSERT INTO `wy_area` VALUES (150581, '霍林郭勒市', 150500, 9);
INSERT INTO `wy_area` VALUES (150600, '鄂尔多斯市', 150000, 6);
INSERT INTO `wy_area` VALUES (150602, '东胜区', 150600, 1);
INSERT INTO `wy_area` VALUES (150621, '达拉特旗', 150600, 2);
INSERT INTO `wy_area` VALUES (150622, '准格尔旗', 150600, 3);
INSERT INTO `wy_area` VALUES (150623, '鄂托克前旗', 150600, 4);
INSERT INTO `wy_area` VALUES (150624, '鄂托克旗', 150600, 5);
INSERT INTO `wy_area` VALUES (150625, '杭锦旗', 150600, 6);
INSERT INTO `wy_area` VALUES (150626, '乌审旗', 150600, 7);
INSERT INTO `wy_area` VALUES (150627, '伊金霍洛旗', 150600, 8);
INSERT INTO `wy_area` VALUES (150700, '呼伦贝尔市', 150000, 7);
INSERT INTO `wy_area` VALUES (150701, '市辖区', 150700, 1);
INSERT INTO `wy_area` VALUES (150702, '海拉尔区', 150700, 2);
INSERT INTO `wy_area` VALUES (150721, '阿荣旗', 150700, 3);
INSERT INTO `wy_area` VALUES (150722, '莫力达瓦达斡尔族自治旗', 150700, 4);
INSERT INTO `wy_area` VALUES (150723, '鄂伦春自治旗', 150700, 5);
INSERT INTO `wy_area` VALUES (150724, '鄂温克族自治旗', 150700, 6);
INSERT INTO `wy_area` VALUES (150725, '陈巴尔虎旗', 150700, 7);
INSERT INTO `wy_area` VALUES (150726, '新巴尔虎左旗', 150700, 8);
INSERT INTO `wy_area` VALUES (150727, '新巴尔虎右旗', 150700, 9);
INSERT INTO `wy_area` VALUES (150781, '满洲里市', 150700, 10);
INSERT INTO `wy_area` VALUES (150782, '牙克石市', 150700, 11);
INSERT INTO `wy_area` VALUES (150783, '扎兰屯市', 150700, 12);
INSERT INTO `wy_area` VALUES (150784, '额尔古纳市', 150700, 13);
INSERT INTO `wy_area` VALUES (150785, '根河市', 150700, 14);
INSERT INTO `wy_area` VALUES (150800, '巴彦淖尔市', 150000, 8);
INSERT INTO `wy_area` VALUES (150801, '市辖区', 150800, 1);
INSERT INTO `wy_area` VALUES (150802, '临河区', 150800, 2);
INSERT INTO `wy_area` VALUES (150821, '五原县', 150800, 3);
INSERT INTO `wy_area` VALUES (150822, '磴口县', 150800, 4);
INSERT INTO `wy_area` VALUES (150823, '乌拉特前旗', 150800, 5);
INSERT INTO `wy_area` VALUES (150824, '乌拉特中旗', 150800, 6);
INSERT INTO `wy_area` VALUES (150825, '乌拉特后旗', 150800, 7);
INSERT INTO `wy_area` VALUES (150826, '杭锦后旗', 150800, 8);
INSERT INTO `wy_area` VALUES (150900, '乌兰察布市', 150000, 9);
INSERT INTO `wy_area` VALUES (150901, '市辖区', 150900, 1);
INSERT INTO `wy_area` VALUES (150902, '集宁区', 150900, 2);
INSERT INTO `wy_area` VALUES (150921, '卓资县', 150900, 3);
INSERT INTO `wy_area` VALUES (150922, '化德县', 150900, 4);
INSERT INTO `wy_area` VALUES (150923, '商都县', 150900, 5);
INSERT INTO `wy_area` VALUES (150924, '兴和县', 150900, 6);
INSERT INTO `wy_area` VALUES (150925, '凉城县', 150900, 7);
INSERT INTO `wy_area` VALUES (150926, '察哈尔右翼前旗', 150900, 8);
INSERT INTO `wy_area` VALUES (150927, '察哈尔右翼中旗', 150900, 9);
INSERT INTO `wy_area` VALUES (150928, '察哈尔右翼后旗', 150900, 10);
INSERT INTO `wy_area` VALUES (150929, '四子王旗', 150900, 11);
INSERT INTO `wy_area` VALUES (150981, '丰镇市', 150900, 12);
INSERT INTO `wy_area` VALUES (152200, '兴安盟', 150000, 10);
INSERT INTO `wy_area` VALUES (152201, '乌兰浩特市', 152200, 1);
INSERT INTO `wy_area` VALUES (152202, '阿尔山市', 152200, 2);
INSERT INTO `wy_area` VALUES (152221, '科尔沁右翼前旗', 152200, 3);
INSERT INTO `wy_area` VALUES (152222, '科尔沁右翼中旗', 152200, 4);
INSERT INTO `wy_area` VALUES (152223, '扎赉特旗', 152200, 5);
INSERT INTO `wy_area` VALUES (152224, '突泉县', 152200, 6);
INSERT INTO `wy_area` VALUES (152500, '锡林郭勒盟', 150000, 11);
INSERT INTO `wy_area` VALUES (152501, '二连浩特市', 152500, 1);
INSERT INTO `wy_area` VALUES (152502, '锡林浩特市', 152500, 2);
INSERT INTO `wy_area` VALUES (152522, '阿巴嘎旗', 152500, 3);
INSERT INTO `wy_area` VALUES (152523, '苏尼特左旗', 152500, 4);
INSERT INTO `wy_area` VALUES (152524, '苏尼特右旗', 152500, 5);
INSERT INTO `wy_area` VALUES (152525, '东乌珠穆沁旗', 152500, 6);
INSERT INTO `wy_area` VALUES (152526, '西乌珠穆沁旗', 152500, 7);
INSERT INTO `wy_area` VALUES (152527, '太仆寺旗', 152500, 8);
INSERT INTO `wy_area` VALUES (152528, '镶黄旗', 152500, 9);
INSERT INTO `wy_area` VALUES (152529, '正镶白旗', 152500, 10);
INSERT INTO `wy_area` VALUES (152530, '正蓝旗', 152500, 11);
INSERT INTO `wy_area` VALUES (152531, '多伦县', 152500, 12);
INSERT INTO `wy_area` VALUES (152900, '阿拉善盟', 150000, 12);
INSERT INTO `wy_area` VALUES (152921, '阿拉善左旗', 152900, 1);
INSERT INTO `wy_area` VALUES (152922, '阿拉善右旗', 152900, 2);
INSERT INTO `wy_area` VALUES (152923, '额济纳旗', 152900, 3);
INSERT INTO `wy_area` VALUES (210000, '辽宁省', 0, 6);
INSERT INTO `wy_area` VALUES (210100, '沈阳市', 210000, 1);
INSERT INTO `wy_area` VALUES (210101, '市辖区', 210100, 1);
INSERT INTO `wy_area` VALUES (210102, '和平区', 210100, 2);
INSERT INTO `wy_area` VALUES (210103, '沈河区', 210100, 3);
INSERT INTO `wy_area` VALUES (210104, '大东区', 210100, 4);
INSERT INTO `wy_area` VALUES (210105, '皇姑区', 210100, 5);
INSERT INTO `wy_area` VALUES (210106, '铁西区', 210100, 6);
INSERT INTO `wy_area` VALUES (210111, '苏家屯区', 210100, 7);
INSERT INTO `wy_area` VALUES (210112, '东陵区', 210100, 8);
INSERT INTO `wy_area` VALUES (210113, '新城子区', 210100, 9);
INSERT INTO `wy_area` VALUES (210114, '于洪区', 210100, 10);
INSERT INTO `wy_area` VALUES (210122, '辽中县', 210100, 11);
INSERT INTO `wy_area` VALUES (210123, '康平县', 210100, 12);
INSERT INTO `wy_area` VALUES (210124, '法库县', 210100, 13);
INSERT INTO `wy_area` VALUES (210181, '新民市', 210100, 14);
INSERT INTO `wy_area` VALUES (210200, '大连市', 210000, 2);
INSERT INTO `wy_area` VALUES (210201, '市辖区', 210200, 1);
INSERT INTO `wy_area` VALUES (210202, '中山区', 210200, 2);
INSERT INTO `wy_area` VALUES (210203, '西岗区', 210200, 3);
INSERT INTO `wy_area` VALUES (210204, '沙河口区', 210200, 4);
INSERT INTO `wy_area` VALUES (210211, '甘井子区', 210200, 5);
INSERT INTO `wy_area` VALUES (210212, '旅顺口区', 210200, 6);
INSERT INTO `wy_area` VALUES (210213, '金州区', 210200, 7);
INSERT INTO `wy_area` VALUES (210224, '长海县', 210200, 8);
INSERT INTO `wy_area` VALUES (210281, '瓦房店市', 210200, 9);
INSERT INTO `wy_area` VALUES (210282, '普兰店市', 210200, 10);
INSERT INTO `wy_area` VALUES (210283, '庄河市', 210200, 11);
INSERT INTO `wy_area` VALUES (210300, '鞍山市', 210000, 3);
INSERT INTO `wy_area` VALUES (210301, '市辖区', 210300, 1);
INSERT INTO `wy_area` VALUES (210302, '铁东区', 210300, 2);
INSERT INTO `wy_area` VALUES (210303, '铁西区', 210300, 3);
INSERT INTO `wy_area` VALUES (210304, '立山区', 210300, 4);
INSERT INTO `wy_area` VALUES (210311, '千山区', 210300, 5);
INSERT INTO `wy_area` VALUES (210321, '台安县', 210300, 6);
INSERT INTO `wy_area` VALUES (210323, '岫岩满族自治县', 210300, 7);
INSERT INTO `wy_area` VALUES (210381, '海城市', 210300, 8);
INSERT INTO `wy_area` VALUES (210400, '抚顺市', 210000, 4);
INSERT INTO `wy_area` VALUES (210401, '市辖区', 210400, 1);
INSERT INTO `wy_area` VALUES (210402, '新抚区', 210400, 2);
INSERT INTO `wy_area` VALUES (210403, '东洲区', 210400, 3);
INSERT INTO `wy_area` VALUES (210404, '望花区', 210400, 4);
INSERT INTO `wy_area` VALUES (210411, '顺城区', 210400, 5);
INSERT INTO `wy_area` VALUES (210421, '抚顺县', 210400, 6);
INSERT INTO `wy_area` VALUES (210422, '新宾满族自治县', 210400, 7);
INSERT INTO `wy_area` VALUES (210423, '清原满族自治县', 210400, 8);
INSERT INTO `wy_area` VALUES (210500, '本溪市', 210000, 5);
INSERT INTO `wy_area` VALUES (210501, '市辖区', 210500, 1);
INSERT INTO `wy_area` VALUES (210502, '平山区', 210500, 2);
INSERT INTO `wy_area` VALUES (210503, '溪湖区', 210500, 3);
INSERT INTO `wy_area` VALUES (210504, '明山区', 210500, 4);
INSERT INTO `wy_area` VALUES (210505, '南芬区', 210500, 5);
INSERT INTO `wy_area` VALUES (210521, '本溪满族自治县', 210500, 6);
INSERT INTO `wy_area` VALUES (210522, '桓仁满族自治县', 210500, 7);
INSERT INTO `wy_area` VALUES (210600, '丹东市', 210000, 6);
INSERT INTO `wy_area` VALUES (210601, '市辖区', 210600, 1);
INSERT INTO `wy_area` VALUES (210602, '元宝区', 210600, 2);
INSERT INTO `wy_area` VALUES (210603, '振兴区', 210600, 3);
INSERT INTO `wy_area` VALUES (210604, '振安区', 210600, 4);
INSERT INTO `wy_area` VALUES (210624, '宽甸满族自治县', 210600, 5);
INSERT INTO `wy_area` VALUES (210681, '东港市', 210600, 6);
INSERT INTO `wy_area` VALUES (210682, '凤城市', 210600, 7);
INSERT INTO `wy_area` VALUES (210700, '锦州市', 210000, 7);
INSERT INTO `wy_area` VALUES (210701, '市辖区', 210700, 1);
INSERT INTO `wy_area` VALUES (210702, '古塔区', 210700, 2);
INSERT INTO `wy_area` VALUES (210703, '凌河区', 210700, 3);
INSERT INTO `wy_area` VALUES (210711, '太和区', 210700, 4);
INSERT INTO `wy_area` VALUES (210726, '黑山县', 210700, 5);
INSERT INTO `wy_area` VALUES (210727, '义　县', 210700, 6);
INSERT INTO `wy_area` VALUES (210781, '凌海市', 210700, 7);
INSERT INTO `wy_area` VALUES (210782, '北宁市', 210700, 8);
INSERT INTO `wy_area` VALUES (210800, '营口市', 210000, 8);
INSERT INTO `wy_area` VALUES (210801, '市辖区', 210800, 1);
INSERT INTO `wy_area` VALUES (210802, '站前区', 210800, 2);
INSERT INTO `wy_area` VALUES (210803, '西市区', 210800, 3);
INSERT INTO `wy_area` VALUES (210804, '鲅鱼圈区', 210800, 4);
INSERT INTO `wy_area` VALUES (210811, '老边区', 210800, 5);
INSERT INTO `wy_area` VALUES (210881, '盖州市', 210800, 6);
INSERT INTO `wy_area` VALUES (210882, '大石桥市', 210800, 7);
INSERT INTO `wy_area` VALUES (210900, '阜新市', 210000, 9);
INSERT INTO `wy_area` VALUES (210901, '市辖区', 210900, 1);
INSERT INTO `wy_area` VALUES (210902, '海州区', 210900, 2);
INSERT INTO `wy_area` VALUES (210903, '新邱区', 210900, 3);
INSERT INTO `wy_area` VALUES (210904, '太平区', 210900, 4);
INSERT INTO `wy_area` VALUES (210905, '清河门区', 210900, 5);
INSERT INTO `wy_area` VALUES (210911, '细河区', 210900, 6);
INSERT INTO `wy_area` VALUES (210921, '阜新蒙古族自治县', 210900, 7);
INSERT INTO `wy_area` VALUES (210922, '彰武县', 210900, 8);
INSERT INTO `wy_area` VALUES (211000, '辽阳市', 210000, 10);
INSERT INTO `wy_area` VALUES (211001, '市辖区', 211000, 1);
INSERT INTO `wy_area` VALUES (211002, '白塔区', 211000, 2);
INSERT INTO `wy_area` VALUES (211003, '文圣区', 211000, 3);
INSERT INTO `wy_area` VALUES (211004, '宏伟区', 211000, 4);
INSERT INTO `wy_area` VALUES (211005, '弓长岭区', 211000, 5);
INSERT INTO `wy_area` VALUES (211011, '太子河区', 211000, 6);
INSERT INTO `wy_area` VALUES (211021, '辽阳县', 211000, 7);
INSERT INTO `wy_area` VALUES (211081, '灯塔市', 211000, 8);
INSERT INTO `wy_area` VALUES (211100, '盘锦市', 210000, 11);
INSERT INTO `wy_area` VALUES (211101, '市辖区', 211100, 1);
INSERT INTO `wy_area` VALUES (211102, '双台子区', 211100, 2);
INSERT INTO `wy_area` VALUES (211103, '兴隆台区', 211100, 3);
INSERT INTO `wy_area` VALUES (211121, '大洼县', 211100, 4);
INSERT INTO `wy_area` VALUES (211122, '盘山县', 211100, 5);
INSERT INTO `wy_area` VALUES (211200, '铁岭市', 210000, 12);
INSERT INTO `wy_area` VALUES (211201, '市辖区', 211200, 1);
INSERT INTO `wy_area` VALUES (211202, '银州区', 211200, 2);
INSERT INTO `wy_area` VALUES (211204, '清河区', 211200, 3);
INSERT INTO `wy_area` VALUES (211221, '铁岭县', 211200, 4);
INSERT INTO `wy_area` VALUES (211223, '西丰县', 211200, 5);
INSERT INTO `wy_area` VALUES (211224, '昌图县', 211200, 6);
INSERT INTO `wy_area` VALUES (211281, '调兵山市', 211200, 7);
INSERT INTO `wy_area` VALUES (211282, '开原市', 211200, 8);
INSERT INTO `wy_area` VALUES (211300, '朝阳市', 210000, 13);
INSERT INTO `wy_area` VALUES (211301, '市辖区', 211300, 1);
INSERT INTO `wy_area` VALUES (211302, '双塔区', 211300, 2);
INSERT INTO `wy_area` VALUES (211303, '龙城区', 211300, 3);
INSERT INTO `wy_area` VALUES (211321, '朝阳县', 211300, 4);
INSERT INTO `wy_area` VALUES (211322, '建平县', 211300, 5);
INSERT INTO `wy_area` VALUES (211324, '喀喇沁左翼蒙古族自治县', 211300, 6);
INSERT INTO `wy_area` VALUES (211381, '北票市', 211300, 7);
INSERT INTO `wy_area` VALUES (211382, '凌源市', 211300, 8);
INSERT INTO `wy_area` VALUES (211400, '葫芦岛市', 210000, 14);
INSERT INTO `wy_area` VALUES (211401, '市辖区', 211400, 1);
INSERT INTO `wy_area` VALUES (211402, '连山区', 211400, 2);
INSERT INTO `wy_area` VALUES (211403, '龙港区', 211400, 3);
INSERT INTO `wy_area` VALUES (211404, '南票区', 211400, 4);
INSERT INTO `wy_area` VALUES (211421, '绥中县', 211400, 5);
INSERT INTO `wy_area` VALUES (211422, '建昌县', 211400, 6);
INSERT INTO `wy_area` VALUES (211481, '兴城市', 211400, 7);
INSERT INTO `wy_area` VALUES (220000, '吉林省', 0, 7);
INSERT INTO `wy_area` VALUES (220100, '长春市', 220000, 1);
INSERT INTO `wy_area` VALUES (220101, '市辖区', 220100, 1);
INSERT INTO `wy_area` VALUES (220102, '南关区', 220100, 2);
INSERT INTO `wy_area` VALUES (220103, '宽城区', 220100, 3);
INSERT INTO `wy_area` VALUES (220104, '朝阳区', 220100, 4);
INSERT INTO `wy_area` VALUES (220105, '二道区', 220100, 5);
INSERT INTO `wy_area` VALUES (220106, '绿园区', 220100, 6);
INSERT INTO `wy_area` VALUES (220112, '双阳区', 220100, 7);
INSERT INTO `wy_area` VALUES (220122, '农安县', 220100, 8);
INSERT INTO `wy_area` VALUES (220181, '九台市', 220100, 9);
INSERT INTO `wy_area` VALUES (220182, '榆树市', 220100, 10);
INSERT INTO `wy_area` VALUES (220183, '德惠市', 220100, 11);
INSERT INTO `wy_area` VALUES (220200, '吉林市', 220000, 2);
INSERT INTO `wy_area` VALUES (220201, '市辖区', 220200, 1);
INSERT INTO `wy_area` VALUES (220202, '昌邑区', 220200, 2);
INSERT INTO `wy_area` VALUES (220203, '龙潭区', 220200, 3);
INSERT INTO `wy_area` VALUES (220204, '船营区', 220200, 4);
INSERT INTO `wy_area` VALUES (220211, '丰满区', 220200, 5);
INSERT INTO `wy_area` VALUES (220221, '永吉县', 220200, 6);
INSERT INTO `wy_area` VALUES (220281, '蛟河市', 220200, 7);
INSERT INTO `wy_area` VALUES (220282, '桦甸市', 220200, 8);
INSERT INTO `wy_area` VALUES (220283, '舒兰市', 220200, 9);
INSERT INTO `wy_area` VALUES (220284, '磐石市', 220200, 10);
INSERT INTO `wy_area` VALUES (220300, '四平市', 220000, 3);
INSERT INTO `wy_area` VALUES (220301, '市辖区', 220300, 1);
INSERT INTO `wy_area` VALUES (220302, '铁西区', 220300, 2);
INSERT INTO `wy_area` VALUES (220303, '铁东区', 220300, 3);
INSERT INTO `wy_area` VALUES (220322, '梨树县', 220300, 4);
INSERT INTO `wy_area` VALUES (220323, '伊通满族自治县', 220300, 5);
INSERT INTO `wy_area` VALUES (220381, '公主岭市', 220300, 6);
INSERT INTO `wy_area` VALUES (220382, '双辽市', 220300, 7);
INSERT INTO `wy_area` VALUES (220400, '辽源市', 220000, 4);
INSERT INTO `wy_area` VALUES (220401, '市辖区', 220400, 1);
INSERT INTO `wy_area` VALUES (220402, '龙山区', 220400, 2);
INSERT INTO `wy_area` VALUES (220403, '西安区', 220400, 3);
INSERT INTO `wy_area` VALUES (220421, '东丰县', 220400, 4);
INSERT INTO `wy_area` VALUES (220422, '东辽县', 220400, 5);
INSERT INTO `wy_area` VALUES (220500, '通化市', 220000, 5);
INSERT INTO `wy_area` VALUES (220501, '市辖区', 220500, 1);
INSERT INTO `wy_area` VALUES (220502, '东昌区', 220500, 2);
INSERT INTO `wy_area` VALUES (220503, '二道江区', 220500, 3);
INSERT INTO `wy_area` VALUES (220521, '通化县', 220500, 4);
INSERT INTO `wy_area` VALUES (220523, '辉南县', 220500, 5);
INSERT INTO `wy_area` VALUES (220524, '柳河县', 220500, 6);
INSERT INTO `wy_area` VALUES (220581, '梅河口市', 220500, 7);
INSERT INTO `wy_area` VALUES (220582, '集安市', 220500, 8);
INSERT INTO `wy_area` VALUES (220600, '白山市', 220000, 6);
INSERT INTO `wy_area` VALUES (220601, '市辖区', 220600, 1);
INSERT INTO `wy_area` VALUES (220602, '八道江区', 220600, 2);
INSERT INTO `wy_area` VALUES (220621, '抚松县', 220600, 3);
INSERT INTO `wy_area` VALUES (220622, '靖宇县', 220600, 4);
INSERT INTO `wy_area` VALUES (220623, '长白朝鲜族自治县', 220600, 5);
INSERT INTO `wy_area` VALUES (220625, '江源县', 220600, 6);
INSERT INTO `wy_area` VALUES (220681, '临江市', 220600, 7);
INSERT INTO `wy_area` VALUES (220700, '松原市', 220000, 7);
INSERT INTO `wy_area` VALUES (220701, '市辖区', 220700, 1);
INSERT INTO `wy_area` VALUES (220702, '宁江区', 220700, 2);
INSERT INTO `wy_area` VALUES (220721, '前郭尔罗斯蒙古族自治县', 220700, 3);
INSERT INTO `wy_area` VALUES (220722, '长岭县', 220700, 4);
INSERT INTO `wy_area` VALUES (220723, '乾安县', 220700, 5);
INSERT INTO `wy_area` VALUES (220724, '扶余县', 220700, 6);
INSERT INTO `wy_area` VALUES (220800, '白城市', 220000, 8);
INSERT INTO `wy_area` VALUES (220801, '市辖区', 220800, 1);
INSERT INTO `wy_area` VALUES (220802, '洮北区', 220800, 2);
INSERT INTO `wy_area` VALUES (220821, '镇赉县', 220800, 3);
INSERT INTO `wy_area` VALUES (220822, '通榆县', 220800, 4);
INSERT INTO `wy_area` VALUES (220881, '洮南市', 220800, 5);
INSERT INTO `wy_area` VALUES (220882, '大安市', 220800, 6);
INSERT INTO `wy_area` VALUES (222400, '延边朝鲜族自治州', 220000, 9);
INSERT INTO `wy_area` VALUES (222401, '延吉市', 222400, 1);
INSERT INTO `wy_area` VALUES (222402, '图们市', 222400, 2);
INSERT INTO `wy_area` VALUES (222403, '敦化市', 222400, 3);
INSERT INTO `wy_area` VALUES (222404, '珲春市', 222400, 4);
INSERT INTO `wy_area` VALUES (222405, '龙井市', 222400, 5);
INSERT INTO `wy_area` VALUES (222406, '和龙市', 222400, 6);
INSERT INTO `wy_area` VALUES (222424, '汪清县', 222400, 7);
INSERT INTO `wy_area` VALUES (222426, '安图县', 222400, 8);
INSERT INTO `wy_area` VALUES (230000, '黑龙江', 0, 8);
INSERT INTO `wy_area` VALUES (230100, '哈尔滨市', 230000, 1);
INSERT INTO `wy_area` VALUES (230101, '市辖区', 230100, 1);
INSERT INTO `wy_area` VALUES (230102, '道里区', 230100, 2);
INSERT INTO `wy_area` VALUES (230103, '南岗区', 230100, 3);
INSERT INTO `wy_area` VALUES (230104, '道外区', 230100, 4);
INSERT INTO `wy_area` VALUES (230106, '香坊区', 230100, 5);
INSERT INTO `wy_area` VALUES (230107, '动力区', 230100, 6);
INSERT INTO `wy_area` VALUES (230108, '平房区', 230100, 7);
INSERT INTO `wy_area` VALUES (230109, '松北区', 230100, 8);
INSERT INTO `wy_area` VALUES (230111, '呼兰区', 230100, 9);
INSERT INTO `wy_area` VALUES (230123, '依兰县', 230100, 10);
INSERT INTO `wy_area` VALUES (230124, '方正县', 230100, 11);
INSERT INTO `wy_area` VALUES (230125, '宾　县', 230100, 12);
INSERT INTO `wy_area` VALUES (230126, '巴彦县', 230100, 13);
INSERT INTO `wy_area` VALUES (230127, '木兰县', 230100, 14);
INSERT INTO `wy_area` VALUES (230128, '通河县', 230100, 15);
INSERT INTO `wy_area` VALUES (230129, '延寿县', 230100, 16);
INSERT INTO `wy_area` VALUES (230181, '阿城市', 230100, 17);
INSERT INTO `wy_area` VALUES (230182, '双城市', 230100, 18);
INSERT INTO `wy_area` VALUES (230183, '尚志市', 230100, 19);
INSERT INTO `wy_area` VALUES (230184, '五常市', 230100, 20);
INSERT INTO `wy_area` VALUES (230200, '齐齐哈尔市', 230000, 2);
INSERT INTO `wy_area` VALUES (230201, '市辖区', 230200, 1);
INSERT INTO `wy_area` VALUES (230202, '龙沙区', 230200, 2);
INSERT INTO `wy_area` VALUES (230203, '建华区', 230200, 3);
INSERT INTO `wy_area` VALUES (230204, '铁锋区', 230200, 4);
INSERT INTO `wy_area` VALUES (230205, '昂昂溪区', 230200, 5);
INSERT INTO `wy_area` VALUES (230206, '富拉尔基区', 230200, 6);
INSERT INTO `wy_area` VALUES (230207, '碾子山区', 230200, 7);
INSERT INTO `wy_area` VALUES (230208, '梅里斯达斡尔族区', 230200, 8);
INSERT INTO `wy_area` VALUES (230221, '龙江县', 230200, 9);
INSERT INTO `wy_area` VALUES (230223, '依安县', 230200, 10);
INSERT INTO `wy_area` VALUES (230224, '泰来县', 230200, 11);
INSERT INTO `wy_area` VALUES (230225, '甘南县', 230200, 12);
INSERT INTO `wy_area` VALUES (230227, '富裕县', 230200, 13);
INSERT INTO `wy_area` VALUES (230229, '克山县', 230200, 14);
INSERT INTO `wy_area` VALUES (230230, '克东县', 230200, 15);
INSERT INTO `wy_area` VALUES (230231, '拜泉县', 230200, 16);
INSERT INTO `wy_area` VALUES (230281, '讷河市', 230200, 17);
INSERT INTO `wy_area` VALUES (230300, '鸡西市', 230000, 3);
INSERT INTO `wy_area` VALUES (230301, '市辖区', 230300, 1);
INSERT INTO `wy_area` VALUES (230302, '鸡冠区', 230300, 2);
INSERT INTO `wy_area` VALUES (230303, '恒山区', 230300, 3);
INSERT INTO `wy_area` VALUES (230304, '滴道区', 230300, 4);
INSERT INTO `wy_area` VALUES (230305, '梨树区', 230300, 5);
INSERT INTO `wy_area` VALUES (230306, '城子河区', 230300, 6);
INSERT INTO `wy_area` VALUES (230307, '麻山区', 230300, 7);
INSERT INTO `wy_area` VALUES (230321, '鸡东县', 230300, 8);
INSERT INTO `wy_area` VALUES (230381, '虎林市', 230300, 9);
INSERT INTO `wy_area` VALUES (230382, '密山市', 230300, 10);
INSERT INTO `wy_area` VALUES (230400, '鹤岗市', 230000, 4);
INSERT INTO `wy_area` VALUES (230401, '市辖区', 230400, 1);
INSERT INTO `wy_area` VALUES (230402, '向阳区', 230400, 2);
INSERT INTO `wy_area` VALUES (230403, '工农区', 230400, 3);
INSERT INTO `wy_area` VALUES (230404, '南山区', 230400, 4);
INSERT INTO `wy_area` VALUES (230405, '兴安区', 230400, 5);
INSERT INTO `wy_area` VALUES (230406, '东山区', 230400, 6);
INSERT INTO `wy_area` VALUES (230407, '兴山区', 230400, 7);
INSERT INTO `wy_area` VALUES (230421, '萝北县', 230400, 8);
INSERT INTO `wy_area` VALUES (230422, '绥滨县', 230400, 9);
INSERT INTO `wy_area` VALUES (230500, '双鸭山市', 230000, 5);
INSERT INTO `wy_area` VALUES (230501, '市辖区', 230500, 1);
INSERT INTO `wy_area` VALUES (230502, '尖山区', 230500, 2);
INSERT INTO `wy_area` VALUES (230503, '岭东区', 230500, 3);
INSERT INTO `wy_area` VALUES (230505, '四方台区', 230500, 4);
INSERT INTO `wy_area` VALUES (230506, '宝山区', 230500, 5);
INSERT INTO `wy_area` VALUES (230521, '集贤县', 230500, 6);
INSERT INTO `wy_area` VALUES (230522, '友谊县', 230500, 7);
INSERT INTO `wy_area` VALUES (230523, '宝清县', 230500, 8);
INSERT INTO `wy_area` VALUES (230524, '饶河县', 230500, 9);
INSERT INTO `wy_area` VALUES (230600, '大庆市', 230000, 6);
INSERT INTO `wy_area` VALUES (230601, '市辖区', 230600, 1);
INSERT INTO `wy_area` VALUES (230602, '萨尔图区', 230600, 2);
INSERT INTO `wy_area` VALUES (230603, '龙凤区', 230600, 3);
INSERT INTO `wy_area` VALUES (230604, '让胡路区', 230600, 4);
INSERT INTO `wy_area` VALUES (230605, '红岗区', 230600, 5);
INSERT INTO `wy_area` VALUES (230606, '大同区', 230600, 6);
INSERT INTO `wy_area` VALUES (230621, '肇州县', 230600, 7);
INSERT INTO `wy_area` VALUES (230622, '肇源县', 230600, 8);
INSERT INTO `wy_area` VALUES (230623, '林甸县', 230600, 9);
INSERT INTO `wy_area` VALUES (230624, '杜尔伯特蒙古族自治县', 230600, 10);
INSERT INTO `wy_area` VALUES (230700, '伊春市', 230000, 7);
INSERT INTO `wy_area` VALUES (230701, '市辖区', 230700, 1);
INSERT INTO `wy_area` VALUES (230702, '伊春区', 230700, 2);
INSERT INTO `wy_area` VALUES (230703, '南岔区', 230700, 3);
INSERT INTO `wy_area` VALUES (230704, '友好区', 230700, 4);
INSERT INTO `wy_area` VALUES (230705, '西林区', 230700, 5);
INSERT INTO `wy_area` VALUES (230706, '翠峦区', 230700, 6);
INSERT INTO `wy_area` VALUES (230707, '新青区', 230700, 7);
INSERT INTO `wy_area` VALUES (230708, '美溪区', 230700, 8);
INSERT INTO `wy_area` VALUES (230709, '金山屯区', 230700, 9);
INSERT INTO `wy_area` VALUES (230710, '五营区', 230700, 10);
INSERT INTO `wy_area` VALUES (230711, '乌马河区', 230700, 11);
INSERT INTO `wy_area` VALUES (230712, '汤旺河区', 230700, 12);
INSERT INTO `wy_area` VALUES (230713, '带岭区', 230700, 13);
INSERT INTO `wy_area` VALUES (230714, '乌伊岭区', 230700, 14);
INSERT INTO `wy_area` VALUES (230715, '红星区', 230700, 15);
INSERT INTO `wy_area` VALUES (230716, '上甘岭区', 230700, 16);
INSERT INTO `wy_area` VALUES (230722, '嘉荫县', 230700, 17);
INSERT INTO `wy_area` VALUES (230781, '铁力市', 230700, 18);
INSERT INTO `wy_area` VALUES (230800, '佳木斯市', 230000, 8);
INSERT INTO `wy_area` VALUES (230801, '市辖区', 230800, 1);
INSERT INTO `wy_area` VALUES (230802, '永红区', 230800, 2);
INSERT INTO `wy_area` VALUES (230803, '向阳区', 230800, 3);
INSERT INTO `wy_area` VALUES (230804, '前进区', 230800, 4);
INSERT INTO `wy_area` VALUES (230805, '东风区', 230800, 5);
INSERT INTO `wy_area` VALUES (230811, '郊　区', 230800, 6);
INSERT INTO `wy_area` VALUES (230822, '桦南县', 230800, 7);
INSERT INTO `wy_area` VALUES (230826, '桦川县', 230800, 8);
INSERT INTO `wy_area` VALUES (230828, '汤原县', 230800, 9);
INSERT INTO `wy_area` VALUES (230833, '抚远县', 230800, 10);
INSERT INTO `wy_area` VALUES (230881, '同江市', 230800, 11);
INSERT INTO `wy_area` VALUES (230882, '富锦市', 230800, 12);
INSERT INTO `wy_area` VALUES (230900, '七台河市', 230000, 9);
INSERT INTO `wy_area` VALUES (230901, '市辖区', 230900, 1);
INSERT INTO `wy_area` VALUES (230902, '新兴区', 230900, 2);
INSERT INTO `wy_area` VALUES (230903, '桃山区', 230900, 3);
INSERT INTO `wy_area` VALUES (230904, '茄子河区', 230900, 4);
INSERT INTO `wy_area` VALUES (230921, '勃利县', 230900, 5);
INSERT INTO `wy_area` VALUES (231000, '牡丹江市', 230000, 10);
INSERT INTO `wy_area` VALUES (231001, '市辖区', 231000, 1);
INSERT INTO `wy_area` VALUES (231002, '东安区', 231000, 2);
INSERT INTO `wy_area` VALUES (231003, '阳明区', 231000, 3);
INSERT INTO `wy_area` VALUES (231004, '爱民区', 231000, 4);
INSERT INTO `wy_area` VALUES (231005, '西安区', 231000, 5);
INSERT INTO `wy_area` VALUES (231024, '东宁县', 231000, 6);
INSERT INTO `wy_area` VALUES (231025, '林口县', 231000, 7);
INSERT INTO `wy_area` VALUES (231081, '绥芬河市', 231000, 8);
INSERT INTO `wy_area` VALUES (231083, '海林市', 231000, 9);
INSERT INTO `wy_area` VALUES (231084, '宁安市', 231000, 10);
INSERT INTO `wy_area` VALUES (231085, '穆棱市', 231000, 11);
INSERT INTO `wy_area` VALUES (231100, '黑河市', 230000, 11);
INSERT INTO `wy_area` VALUES (231101, '市辖区', 231100, 1);
INSERT INTO `wy_area` VALUES (231102, '爱辉区', 231100, 2);
INSERT INTO `wy_area` VALUES (231121, '嫩江县', 231100, 3);
INSERT INTO `wy_area` VALUES (231123, '逊克县', 231100, 4);
INSERT INTO `wy_area` VALUES (231124, '孙吴县', 231100, 5);
INSERT INTO `wy_area` VALUES (231181, '北安市', 231100, 6);
INSERT INTO `wy_area` VALUES (231182, '五大连池市', 231100, 7);
INSERT INTO `wy_area` VALUES (231200, '绥化市', 230000, 12);
INSERT INTO `wy_area` VALUES (231201, '市辖区', 231200, 1);
INSERT INTO `wy_area` VALUES (231202, '北林区', 231200, 2);
INSERT INTO `wy_area` VALUES (231221, '望奎县', 231200, 3);
INSERT INTO `wy_area` VALUES (231222, '兰西县', 231200, 4);
INSERT INTO `wy_area` VALUES (231223, '青冈县', 231200, 5);
INSERT INTO `wy_area` VALUES (231224, '庆安县', 231200, 6);
INSERT INTO `wy_area` VALUES (231225, '明水县', 231200, 7);
INSERT INTO `wy_area` VALUES (231226, '绥棱县', 231200, 8);
INSERT INTO `wy_area` VALUES (231281, '安达市', 231200, 9);
INSERT INTO `wy_area` VALUES (231282, '肇东市', 231200, 10);
INSERT INTO `wy_area` VALUES (231283, '海伦市', 231200, 11);
INSERT INTO `wy_area` VALUES (232700, '大兴安岭地区', 230000, 13);
INSERT INTO `wy_area` VALUES (232721, '呼玛县', 232700, 1);
INSERT INTO `wy_area` VALUES (232722, '塔河县', 232700, 2);
INSERT INTO `wy_area` VALUES (232723, '漠河县', 232700, 3);
INSERT INTO `wy_area` VALUES (310000, '上海市', 0, 9);
INSERT INTO `wy_area` VALUES (310100, '市辖区', 310000, 1);
INSERT INTO `wy_area` VALUES (310101, '黄浦区', 310100, 1);
INSERT INTO `wy_area` VALUES (310103, '卢湾区', 310100, 2);
INSERT INTO `wy_area` VALUES (310104, '徐汇区', 310100, 3);
INSERT INTO `wy_area` VALUES (310105, '长宁区', 310100, 4);
INSERT INTO `wy_area` VALUES (310106, '静安区', 310100, 5);
INSERT INTO `wy_area` VALUES (310107, '普陀区', 310100, 6);
INSERT INTO `wy_area` VALUES (310108, '闸北区', 310100, 7);
INSERT INTO `wy_area` VALUES (310109, '虹口区', 310100, 8);
INSERT INTO `wy_area` VALUES (310110, '杨浦区', 310100, 9);
INSERT INTO `wy_area` VALUES (310112, '闵行区', 310100, 10);
INSERT INTO `wy_area` VALUES (310113, '宝山区', 310100, 11);
INSERT INTO `wy_area` VALUES (310114, '嘉定区', 310100, 12);
INSERT INTO `wy_area` VALUES (310115, '浦东新区', 310100, 13);
INSERT INTO `wy_area` VALUES (310116, '金山区', 310100, 14);
INSERT INTO `wy_area` VALUES (310117, '松江区', 310100, 15);
INSERT INTO `wy_area` VALUES (310118, '青浦区', 310100, 16);
INSERT INTO `wy_area` VALUES (310119, '南汇区', 310100, 17);
INSERT INTO `wy_area` VALUES (310120, '奉贤区', 310100, 18);
INSERT INTO `wy_area` VALUES (310200, '县', 310000, 2);
INSERT INTO `wy_area` VALUES (310230, '崇明县', 310200, 1);
INSERT INTO `wy_area` VALUES (320000, '江苏省', 0, 10);
INSERT INTO `wy_area` VALUES (320100, '南京市', 320000, 1);
INSERT INTO `wy_area` VALUES (320101, '市辖区', 320100, 1);
INSERT INTO `wy_area` VALUES (320102, '玄武区', 320100, 2);
INSERT INTO `wy_area` VALUES (320103, '白下区', 320100, 3);
INSERT INTO `wy_area` VALUES (320104, '秦淮区', 320100, 4);
INSERT INTO `wy_area` VALUES (320105, '建邺区', 320100, 5);
INSERT INTO `wy_area` VALUES (320106, '鼓楼区', 320100, 6);
INSERT INTO `wy_area` VALUES (320107, '下关区', 320100, 7);
INSERT INTO `wy_area` VALUES (320111, '浦口区', 320100, 8);
INSERT INTO `wy_area` VALUES (320113, '栖霞区', 320100, 9);
INSERT INTO `wy_area` VALUES (320114, '雨花台区', 320100, 10);
INSERT INTO `wy_area` VALUES (320115, '江宁区', 320100, 11);
INSERT INTO `wy_area` VALUES (320116, '六合区', 320100, 12);
INSERT INTO `wy_area` VALUES (320124, '溧水县', 320100, 13);
INSERT INTO `wy_area` VALUES (320125, '高淳县', 320100, 14);
INSERT INTO `wy_area` VALUES (320200, '无锡市', 320000, 2);
INSERT INTO `wy_area` VALUES (320201, '市辖区', 320200, 1);
INSERT INTO `wy_area` VALUES (320202, '崇安区', 320200, 2);
INSERT INTO `wy_area` VALUES (320203, '南长区', 320200, 3);
INSERT INTO `wy_area` VALUES (320204, '北塘区', 320200, 4);
INSERT INTO `wy_area` VALUES (320205, '锡山区', 320200, 5);
INSERT INTO `wy_area` VALUES (320206, '惠山区', 320200, 6);
INSERT INTO `wy_area` VALUES (320211, '滨湖区', 320200, 7);
INSERT INTO `wy_area` VALUES (320281, '江阴市', 320200, 8);
INSERT INTO `wy_area` VALUES (320282, '宜兴市', 320200, 9);
INSERT INTO `wy_area` VALUES (320300, '徐州市', 320000, 3);
INSERT INTO `wy_area` VALUES (320301, '市辖区', 320300, 1);
INSERT INTO `wy_area` VALUES (320302, '鼓楼区', 320300, 2);
INSERT INTO `wy_area` VALUES (320303, '云龙区', 320300, 3);
INSERT INTO `wy_area` VALUES (320304, '九里区', 320300, 4);
INSERT INTO `wy_area` VALUES (320305, '贾汪区', 320300, 5);
INSERT INTO `wy_area` VALUES (320311, '泉山区', 320300, 6);
INSERT INTO `wy_area` VALUES (320321, '丰　县', 320300, 7);
INSERT INTO `wy_area` VALUES (320322, '沛　县', 320300, 8);
INSERT INTO `wy_area` VALUES (320323, '铜山县', 320300, 9);
INSERT INTO `wy_area` VALUES (320324, '睢宁县', 320300, 10);
INSERT INTO `wy_area` VALUES (320381, '新沂市', 320300, 11);
INSERT INTO `wy_area` VALUES (320382, '邳州市', 320300, 12);
INSERT INTO `wy_area` VALUES (320400, '常州市', 320000, 4);
INSERT INTO `wy_area` VALUES (320401, '市辖区', 320400, 1);
INSERT INTO `wy_area` VALUES (320402, '天宁区', 320400, 2);
INSERT INTO `wy_area` VALUES (320404, '钟楼区', 320400, 3);
INSERT INTO `wy_area` VALUES (320405, '戚墅堰区', 320400, 4);
INSERT INTO `wy_area` VALUES (320411, '新北区', 320400, 5);
INSERT INTO `wy_area` VALUES (320412, '武进区', 320400, 6);
INSERT INTO `wy_area` VALUES (320481, '溧阳市', 320400, 7);
INSERT INTO `wy_area` VALUES (320482, '金坛市', 320400, 8);
INSERT INTO `wy_area` VALUES (320500, '苏州市', 320000, 5);
INSERT INTO `wy_area` VALUES (320501, '市辖区', 320500, 1);
INSERT INTO `wy_area` VALUES (320502, '沧浪区', 320500, 2);
INSERT INTO `wy_area` VALUES (320503, '平江区', 320500, 3);
INSERT INTO `wy_area` VALUES (320504, '金阊区', 320500, 4);
INSERT INTO `wy_area` VALUES (320505, '虎丘区', 320500, 5);
INSERT INTO `wy_area` VALUES (320506, '吴中区', 320500, 6);
INSERT INTO `wy_area` VALUES (320507, '相城区', 320500, 7);
INSERT INTO `wy_area` VALUES (320581, '常熟市', 320500, 8);
INSERT INTO `wy_area` VALUES (320582, '张家港市', 320500, 9);
INSERT INTO `wy_area` VALUES (320583, '昆山市', 320500, 10);
INSERT INTO `wy_area` VALUES (320584, '吴江市', 320500, 11);
INSERT INTO `wy_area` VALUES (320585, '太仓市', 320500, 12);
INSERT INTO `wy_area` VALUES (320600, '南通市', 320000, 6);
INSERT INTO `wy_area` VALUES (320601, '市辖区', 320600, 1);
INSERT INTO `wy_area` VALUES (320602, '崇川区', 320600, 2);
INSERT INTO `wy_area` VALUES (320611, '港闸区', 320600, 3);
INSERT INTO `wy_area` VALUES (320621, '海安县', 320600, 4);
INSERT INTO `wy_area` VALUES (320623, '如东县', 320600, 5);
INSERT INTO `wy_area` VALUES (320681, '启东市', 320600, 6);
INSERT INTO `wy_area` VALUES (320682, '如皋市', 320600, 7);
INSERT INTO `wy_area` VALUES (320683, '通州市', 320600, 8);
INSERT INTO `wy_area` VALUES (320684, '海门市', 320600, 9);
INSERT INTO `wy_area` VALUES (320700, '连云港市', 320000, 7);
INSERT INTO `wy_area` VALUES (320701, '市辖区', 320700, 1);
INSERT INTO `wy_area` VALUES (320703, '连云区', 320700, 2);
INSERT INTO `wy_area` VALUES (320705, '新浦区', 320700, 3);
INSERT INTO `wy_area` VALUES (320706, '海州区', 320700, 4);
INSERT INTO `wy_area` VALUES (320721, '赣榆县', 320700, 5);
INSERT INTO `wy_area` VALUES (320722, '东海县', 320700, 6);
INSERT INTO `wy_area` VALUES (320723, '灌云县', 320700, 7);
INSERT INTO `wy_area` VALUES (320724, '灌南县', 320700, 8);
INSERT INTO `wy_area` VALUES (320800, '淮安市', 320000, 8);
INSERT INTO `wy_area` VALUES (320801, '市辖区', 320800, 1);
INSERT INTO `wy_area` VALUES (320802, '清河区', 320800, 2);
INSERT INTO `wy_area` VALUES (320803, '楚州区', 320800, 3);
INSERT INTO `wy_area` VALUES (320804, '淮阴区', 320800, 4);
INSERT INTO `wy_area` VALUES (320811, '清浦区', 320800, 5);
INSERT INTO `wy_area` VALUES (320826, '涟水县', 320800, 6);
INSERT INTO `wy_area` VALUES (320829, '洪泽县', 320800, 7);
INSERT INTO `wy_area` VALUES (320830, '盱眙县', 320800, 8);
INSERT INTO `wy_area` VALUES (320831, '金湖县', 320800, 9);
INSERT INTO `wy_area` VALUES (320900, '盐城市', 320000, 9);
INSERT INTO `wy_area` VALUES (320901, '市辖区', 320900, 1);
INSERT INTO `wy_area` VALUES (320902, '亭湖区', 320900, 2);
INSERT INTO `wy_area` VALUES (320903, '盐都区', 320900, 3);
INSERT INTO `wy_area` VALUES (320921, '响水县', 320900, 4);
INSERT INTO `wy_area` VALUES (320922, '滨海县', 320900, 5);
INSERT INTO `wy_area` VALUES (320923, '阜宁县', 320900, 6);
INSERT INTO `wy_area` VALUES (320924, '射阳县', 320900, 7);
INSERT INTO `wy_area` VALUES (320925, '建湖县', 320900, 8);
INSERT INTO `wy_area` VALUES (320981, '东台市', 320900, 9);
INSERT INTO `wy_area` VALUES (320982, '大丰市', 320900, 10);
INSERT INTO `wy_area` VALUES (321000, '扬州市', 320000, 10);
INSERT INTO `wy_area` VALUES (321001, '市辖区', 321000, 1);
INSERT INTO `wy_area` VALUES (321002, '广陵区', 321000, 2);
INSERT INTO `wy_area` VALUES (321003, '邗江区', 321000, 3);
INSERT INTO `wy_area` VALUES (321011, '郊　区', 321000, 4);
INSERT INTO `wy_area` VALUES (321023, '宝应县', 321000, 5);
INSERT INTO `wy_area` VALUES (321081, '仪征市', 321000, 6);
INSERT INTO `wy_area` VALUES (321084, '高邮市', 321000, 7);
INSERT INTO `wy_area` VALUES (321088, '江都市', 321000, 8);
INSERT INTO `wy_area` VALUES (321100, '镇江市', 320000, 11);
INSERT INTO `wy_area` VALUES (321101, '市辖区', 321100, 1);
INSERT INTO `wy_area` VALUES (321102, '京口区', 321100, 2);
INSERT INTO `wy_area` VALUES (321111, '润州区', 321100, 3);
COMMIT;

-- ----------------------------
-- Table structure for wy_auth
-- ----------------------------
DROP TABLE IF EXISTS `wy_auth`;
CREATE TABLE `wy_auth` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(100) NOT NULL COMMENT '群组名称',
  `remark` varchar(255) NOT NULL COMMENT '备注',
  `is_deleted` tinyint(1) NOT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限表';

-- ----------------------------
-- Table structure for wy_auth_node
-- ----------------------------
DROP TABLE IF EXISTS `wy_auth_node`;
CREATE TABLE `wy_auth_node` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `bs_auth_id` int(11) NOT NULL COMMENT '群组id',
  `routers_id` varchar(100) NOT NULL COMMENT '授权内容',
  `is_deleted` tinyint(1) NOT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限授权节点表';

-- ----------------------------
-- Table structure for wy_bd_info
-- ----------------------------
DROP TABLE IF EXISTS `wy_bd_info`;
CREATE TABLE `wy_bd_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `area` varchar(255) NOT NULL COMMENT '所在地区',
  `address` varchar(255) NOT NULL COMMENT '详细地址',
  `tel` varchar(255) DEFAULT NULL COMMENT '客服电话',
  `contact` varchar(100) DEFAULT NULL COMMENT '负责人',
  `phone` varchar(100) DEFAULT NULL COMMENT '负责人电话',
  `call_name` varchar(255) DEFAULT NULL COMMENT '联系人',
  `call_tel` varchar(100) DEFAULT NULL COMMENT '联系人电话',
  `logo_file` int(10) DEFAULT NULL COMMENT 'logo',
  `bg_img` int(10) DEFAULT NULL COMMENT '背景图',
  `phone_set` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许住户手机号设置：0=允许，1=不允许',
  `floor_area` decimal(10,0) DEFAULT '0' COMMENT '占地面积',
  `edifice_area` decimal(10,0) DEFAULT '0' COMMENT '建筑面积',
  `public_area` decimal(10,0) DEFAULT '0' COMMENT '公共场所面积',
  `green_area` decimal(10,0) DEFAULT '0' COMMENT '绿化面积',
  `car_area` decimal(10,0) DEFAULT '0' COMMENT '车位面积',
  `garage_area` decimal(10,0) DEFAULT '10' COMMENT '车库面积',
  `car_numbers` int(11) DEFAULT '0' COMMENT '车位数',
  `building_numbers` int(10) NOT NULL DEFAULT '5' COMMENT '楼宇数量',
  `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='小区';

-- ----------------------------
-- Table structure for wy_building
-- ----------------------------
DROP TABLE IF EXISTS `wy_building`;
CREATE TABLE `wy_building` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `bd_info_id` int(11) NOT NULL COMMENT '所属小区',
  `name` varchar(100) NOT NULL COMMENT '楼宇名称',
  `unit_num` int(11) NOT NULL COMMENT '单元数量',
  `layers` int(10) NOT NULL COMMENT '层数',
  `type` varchar(100) DEFAULT NULL COMMENT '类型:高层或者多层',
  `struct` varchar(255) DEFAULT NULL COMMENT '结构',
  `direction` varchar(255) DEFAULT NULL COMMENT '朝向',
  `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='楼宇';

-- ----------------------------
-- Table structure for wy_car
-- ----------------------------
DROP TABLE IF EXISTS `wy_car`;
CREATE TABLE `wy_car` (
  `id` int(11) NOT NULL COMMENT 'id',
  `house_user_id` int(11) DEFAULT NULL COMMENT '绑定住户',
  `car_area_id` int(11) DEFAULT NULL COMMENT '车位号',
  `name` varchar(255) NOT NULL COMMENT '车牌号',
  `stop_numbers` varchar(0) DEFAULT NULL COMMENT '停车卡号',
  `username` varchar(255) DEFAULT NULL COMMENT '车主姓名',
  `phone` varchar(255) DEFAULT NULL COMMENT '车主手机号',
  `horsepower` int(10) DEFAULT NULL COMMENT '车辆排量',
  `car_model` varchar(255) DEFAULT NULL COMMENT '车辆型号',
  `color` varchar(100) DEFAULT NULL COMMENT '车辆颜色',
  `qq` varchar(100) DEFAULT NULL COMMENT '车主qq',
  `prices` varchar(255) DEFAULT NULL COMMENT '收费标准个数',
  `wechat` varchar(100) DEFAULT NULL COMMENT '车主微信',
  `email` varchar(255) DEFAULT NULL COMMENT '车主邮箱',
  `family_tel` varchar(255) DEFAULT NULL COMMENT '家庭电话',
  `car_img` int(10) DEFAULT NULL COMMENT '车辆照片',
  `car_license` int(10) DEFAULT NULL COMMENT '行驶证照片',
  `user_driver` int(10) DEFAULT NULL COMMENT '驾驶证照片',
  `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='车辆';

-- ----------------------------
-- Table structure for wy_car_area
-- ----------------------------
DROP TABLE IF EXISTS `wy_car_area`;
CREATE TABLE `wy_car_area` (
  `id` int(11) NOT NULL COMMENT 'id',
  `bd_info_id` int(11) NOT NULL COMMENT '所属小区',
  `house_user_id` int(11) DEFAULT NULL COMMENT '绑定住户',
  `labels` varchar(255) DEFAULT NULL COMMENT '标签',
  `name` varchar(255) NOT NULL COMMENT '车位号',
  `area` decimal(10,0) NOT NULL COMMENT '产权面积',
  `type` tinyint(1) NOT NULL COMMENT '车位类型：1=人防车位，2=公共车位，3=产权车位',
  `status` tinyint(1) NOT NULL COMMENT '车位状态：1=已售，2=已租，3=空置，4=自用，5=待售，6',
  `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  `prices` varchar(255) DEFAULT NULL COMMENT '收费标准个数',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='车位';

-- ----------------------------
-- Table structure for wy_deposit
-- ----------------------------
DROP TABLE IF EXISTS `wy_deposit`;
CREATE TABLE `wy_deposit` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `price` decimal(10,2) NOT NULL COMMENT '预存款充值金额',
  `money` decimal(10,0) NOT NULL COMMENT '实际支付金额',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='预存款套餐';

-- ----------------------------
-- Table structure for wy_deposit_list
-- ----------------------------
DROP TABLE IF EXISTS `wy_deposit_list`;
CREATE TABLE `wy_deposit_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `bd_info_id` int(11) NOT NULL COMMENT '所属小区',
  `house_user_id` int(11) NOT NULL COMMENT '所属住户',
  `type` tinyint(1) NOT NULL COMMENT '充值类型：1=通用预存款充值，2=专用预存款充值',
  `category_id` tinyint(1) DEFAULT NULL COMMENT '预存款类别',
  `price` decimal(10,2) NOT NULL COMMENT '充值金额',
  `money` decimal(10,0) DEFAULT NULL COMMENT '实收金额',
  `balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='预存款列表';

-- ----------------------------
-- Table structure for wy_deposit_list_store
-- ----------------------------
DROP TABLE IF EXISTS `wy_deposit_list_store`;
CREATE TABLE `wy_deposit_list_store` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `bd_info_id` int(11) NOT NULL COMMENT '所属小区',
  `house_user_id` int(11) NOT NULL COMMENT '所属住户',
  `price` decimal(10,2) NOT NULL COMMENT '预存金额',
  `money` decimal(10,0) NOT NULL COMMENT '实收金额',
  `type` tinyint(1) NOT NULL COMMENT '类型：1=充值，2=抵扣',
  `come` varchar(255) NOT NULL COMMENT '来源',
  `createtime` datetime NOT NULL COMMENT '创建时间',
  `remarks` varchar(255) NOT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='预存款记录明细';

-- ----------------------------
-- Table structure for wy_deposit_set
-- ----------------------------
DROP TABLE IF EXISTS `wy_deposit_set`;
CREATE TABLE `wy_deposit_set` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type` tinyint(1) NOT NULL COMMENT '通用预存款充值设置：1=自由充值，2=自定义套餐，3=关闭充值',
  `deposit_ids` varchar(255) NOT NULL COMMENT '套餐',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='预存款通用设置';

-- ----------------------------
-- Table structure for wy_house_user
-- ----------------------------
DROP TABLE IF EXISTS `wy_house_user`;
CREATE TABLE `wy_house_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `bd_info_id` int(11) NOT NULL COMMENT '所属小区',
  `building_id` int(11) NOT NULL COMMENT '所属楼宇',
  `unit_id` int(11) NOT NULL COMMENT '所属单元',
  `houses_id` int(11) DEFAULT NULL COMMENT '所属房屋',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `gender` tinyint(1) NOT NULL COMMENT '性别：1=男，2=女，3=其他',
  `phone` varchar(255) NOT NULL COMMENT '手机号',
  `type` tinyint(1) NOT NULL COMMENT '住户身份：1=业主本人，2=亲属，3=租客，4=朋友，5=同事，6=保姆，7=司机，8=装修人员，9=其他',
  `createtime` datetime DEFAULT NULL COMMENT '出生日期',
  `card_numbers` varchar(100) DEFAULT NULL COMMENT '业主卡号',
  `work_area` varchar(255) DEFAULT NULL COMMENT '单位',
  `in_time` datetime DEFAULT NULL COMMENT '入住时间',
  `in_text` varchar(255) DEFAULT NULL COMMENT '入住原因',
  `imgs` varchar(255) DEFAULT NULL COMMENT '住户照片',
  `qq` varchar(255) DEFAULT NULL COMMENT 'qq',
  `wechat` varchar(255) DEFAULT NULL COMMENT '微信',
  `email` varchar(255) DEFAULT NULL COMMENT 'email',
  `tel` varchar(255) DEFAULT NULL COMMENT '家庭电话',
  `sos_user` varchar(255) DEFAULT NULL COMMENT '紧急联系人',
  `sos_call` varchar(255) DEFAULT NULL COMMENT '紧急联系人电话',
  `race` int(10) DEFAULT NULL COMMENT '民族',
  `po_status` varchar(255) DEFAULT NULL COMMENT '政治面貌',
  `marriage` varchar(50) DEFAULT NULL COMMENT '婚姻状况',
  `license` varchar(255) DEFAULT NULL COMMENT '身份证',
  `license_img` int(10) DEFAULT NULL COMMENT '身份证照片',
  `account_type` tinyint(1) DEFAULT NULL COMMENT '户口类型',
  `account_address` varchar(255) DEFAULT NULL COMMENT '户口地址',
  `address` varchar(255) DEFAULT NULL COMMENT '详细地址',
  `tem_permit` varchar(255) DEFAULT NULL COMMENT '暂住证号码',
  `tem_type` tinyint(1) DEFAULT NULL COMMENT '居住类型',
  `pet` varchar(255) DEFAULT NULL COMMENT '宠物信息',
  `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  `vali_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '有效期：1=长期，2=短期',
  `login_num` int(11) NOT NULL DEFAULT '0' COMMENT '登陆次数',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态：1=已迁入，2=待审核，3=未通过，4=已迁出',
  `registry_text` varchar(255) DEFAULT NULL COMMENT '注册来源',
  `registry_time` datetime DEFAULT NULL COMMENT '注册时间',
  `registry_remarks` varchar(255) DEFAULT NULL COMMENT '注册说明',
  `registry_no_text` varchar(255) DEFAULT NULL COMMENT '不通过原因',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='住户';

-- ----------------------------
-- Table structure for wy_houses
-- ----------------------------
DROP TABLE IF EXISTS `wy_houses`;
CREATE TABLE `wy_houses` (
  `id` int(11) NOT NULL COMMENT 'id',
  `bd_info_id` int(11) NOT NULL COMMENT '所属小区',
  `building_id` int(11) NOT NULL COMMENT '所属楼宇',
  `house_user_id` int(11) DEFAULT NULL COMMENT '绑定住户',
  `unit_id` int(11) NOT NULL COMMENT '所属单元',
  `floor` int(10) NOT NULL COMMENT '所在楼层',
  `name` varchar(255) NOT NULL COMMENT '房号',
  `area` decimal(10,0) NOT NULL COMMENT '面积',
  `type` tinyint(1) DEFAULT '0' COMMENT '房屋类型:1=住宅，2=公寓，3=办公，4=厂房，5=仓库，6=商铺，7=酒店，8=别墅，9=其他',
  `weights` int(10) DEFAULT '1' COMMENT '投票权数',
  `houses_type` int(10) DEFAULT NULL COMMENT '房屋类型',
  `room_numbers` int(11) DEFAULT NULL COMMENT '室数',
  `hall_numbers` int(11) DEFAULT NULL COMMENT '厅数',
  `guard_numbers` int(11) DEFAULT NULL COMMENT '卫数',
  `direction` varchar(255) DEFAULT NULL COMMENT '房屋朝向',
  `time` datetime DEFAULT NULL COMMENT '交房时间',
  `years` int(10) DEFAULT NULL COMMENT '产权年限',
  `imgs` varchar(255) DEFAULT NULL COMMENT '附件',
  `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  `prices` varchar(255) DEFAULT NULL COMMENT '收费标准',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='房屋';

-- ----------------------------
-- Records of wy_houses
-- ----------------------------
BEGIN;
INSERT INTO `wy_houses` VALUES (0, 0, 0, NULL, 0, 0, '', 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for wy_imgs
-- ----------------------------
DROP TABLE IF EXISTS `wy_imgs`;
CREATE TABLE `wy_imgs` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `url` varchar(255) NOT NULL COMMENT '路径',
  `createtime` datetime NOT NULL COMMENT '上传时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='图片表';

-- ----------------------------
-- Table structure for wy_labels
-- ----------------------------
DROP TABLE IF EXISTS `wy_labels`;
CREATE TABLE `wy_labels` (
  `id` int(11) NOT NULL COMMENT 'id',
  `name` varchar(255) NOT NULL COMMENT '标签名称',
  `type_name` varchar(255) NOT NULL COMMENT '分类',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据标签';

-- ----------------------------
-- Table structure for wy_member
-- ----------------------------
DROP TABLE IF EXISTS `wy_member`;
CREATE TABLE `wy_member` (
  `id` int(11) NOT NULL COMMENT 'id',
  `logo_file` int(10) NOT NULL COMMENT '头像',
  `name` varchar(255) NOT NULL COMMENT '姓名',
  `auth` int(10) NOT NULL COMMENT '身份',
  `phone` varchar(255) DEFAULT NULL COMMENT '手机号',
  `email` varchar(255) DEFAULT NULL COMMENT 'email',
  `qq` varchar(255) DEFAULT NULL COMMENT 'qq',
  `wechat` varchar(255) DEFAULT NULL COMMENT '微信',
  `account` varchar(255) NOT NULL COMMENT '帐号',
  `password` varchar(255) NOT NULL COMMENT '密码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户';

-- ----------------------------
-- Table structure for wy_no_payment
-- ----------------------------
DROP TABLE IF EXISTS `wy_no_payment`;
CREATE TABLE `wy_no_payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type` tinyint(1) NOT NULL COMMENT '类型：1=房屋，2=车辆，3=车位，4=住户',
  `bd_info_id` int(11) NOT NULL COMMENT '所属小区',
  `building_id` int(11) NOT NULL COMMENT '所属楼宇',
  `house_id` int(11) DEFAULT NULL COMMENT '房号',
  `car_area_id` int(11) DEFAULT NULL COMMENT '车位号',
  `car_id` int(11) DEFAULT NULL COMMENT '车牌号',
  `house_user_id` int(11) DEFAULT NULL COMMENT '住户',
  `name` varchar(255) NOT NULL COMMENT '费用名称',
  `createtime` datetime NOT NULL COMMENT '创建时间',
  `tel` varchar(255) NOT NULL COMMENT '手机号',
  `price` decimal(10,2) NOT NULL COMMENT '应收金额',
  `money` decimal(10,0) NOT NULL COMMENT '应缴金额',
  `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `one_money` int(10) NOT NULL COMMENT '单价',
  `num` int(11) NOT NULL COMMENT '数量',
  `offer` decimal(10,0) DEFAULT '0' COMMENT '优惠',
  `overdue` decimal(10,0) DEFAULT '0' COMMENT '滞纳金',
  `deduction` decimal(10,0) DEFAULT '0' COMMENT '预存款抵扣',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='未缴费账单';

-- ----------------------------
-- Table structure for wy_payment
-- ----------------------------
DROP TABLE IF EXISTS `wy_payment`;
CREATE TABLE `wy_payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `bd_info_id` int(11) NOT NULL COMMENT '所属小区',
  `houses_id` int(11) DEFAULT NULL COMMENT '所属房屋',
  `car_area_id` int(11) DEFAULT NULL COMMENT '所属车位',
  `car_id` int(11) DEFAULT NULL COMMENT '所属车辆',
  `house_user_id` int(11) DEFAULT NULL COMMENT '所属住户',
  `price` decimal(10,2) NOT NULL COMMENT '应收金额',
  `money` decimal(10,0) NOT NULL COMMENT '实收金额',
  `pay_time` datetime NOT NULL COMMENT '支付时间',
  `action_user` varchar(255) NOT NULL COMMENT '操作员',
  `pay_style` tinyint(1) NOT NULL COMMENT '收款方式：1=线下支付-现金，2=线下支付-支票，3=线下支付-银行转账，4=线下支付-pos机刷卡，5=线下支付-支付宝直接转账，6=线下支付-微信直接转账，7=小区收款码-支付宝，8=小区收款码-微信',
  `status` tinyint(1) NOT NULL COMMENT '状态：1=已收，2=退款，3=撤销',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='已缴费账单';

-- ----------------------------
-- Table structure for wy_payment_store
-- ----------------------------
DROP TABLE IF EXISTS `wy_payment_store`;
CREATE TABLE `wy_payment_store` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `payment_id` int(11) NOT NULL COMMENT '所属已缴账单',
  `status` tinyint(1) NOT NULL COMMENT '状态',
  `type` tinyint(1) NOT NULL COMMENT '类型',
  `houses_id` int(11) DEFAULT NULL COMMENT '所属房屋',
  `car_area_id` int(11) DEFAULT NULL COMMENT '所属车位',
  `car_id` int(11) DEFAULT NULL COMMENT '所属车牌',
  `name` varchar(255) NOT NULL COMMENT '费用名称',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `one_money` int(10) NOT NULL COMMENT '单价',
  `num` int(11) NOT NULL COMMENT '数量',
  `price` decimal(10,2) NOT NULL COMMENT '应收金额',
  `offer` decimal(10,0) DEFAULT '0' COMMENT '优惠',
  `overdue` decimal(10,0) DEFAULT '0' COMMENT '滞纳金',
  `deduction` decimal(10,0) DEFAULT '0' COMMENT '预存款抵扣',
  `money` decimal(10,0) NOT NULL COMMENT '实收金额',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='已缴账单明细';

-- ----------------------------
-- Table structure for wy_pre_deposit_store
-- ----------------------------
DROP TABLE IF EXISTS `wy_pre_deposit_store`;
CREATE TABLE `wy_pre_deposit_store` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `bd_info_id` int(11) NOT NULL COMMENT '所属小区',
  `house_user_id` int(11) NOT NULL COMMENT '所属住户',
  `price` decimal(10,2) NOT NULL COMMENT '金额',
  `type` tinyint(1) NOT NULL COMMENT '类型',
  `source` tinyint(1) NOT NULL COMMENT '来源：1=系统，2=管理员',
  `createtime` datetime NOT NULL COMMENT '时间',
  `remarks` varchar(255) NOT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='预存款明细';

-- ----------------------------
-- Table structure for wy_routers
-- ----------------------------
DROP TABLE IF EXISTS `wy_routers`;
CREATE TABLE `wy_routers` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type` tinyint(1) NOT NULL COMMENT '端口:0=展会管理端,1=展商',
  `title` varchar(255) NOT NULL COMMENT '标题',
  `key` varchar(100) NOT NULL COMMENT '路由标识',
  `icon` varchar(255) NOT NULL COMMENT '图标',
  `keepAlive` int(10) NOT NULL COMMENT '缓存',
  `component` varchar(255) NOT NULL COMMENT '组建',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='前端一级路由';

-- ----------------------------
-- Table structure for wy_routers_children
-- ----------------------------
DROP TABLE IF EXISTS `wy_routers_children`;
CREATE TABLE `wy_routers_children` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `title` varchar(100) NOT NULL COMMENT '路由名称',
  `key` varchar(255) NOT NULL COMMENT '路由标识',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `keepAlive` int(10) NOT NULL COMMENT '缓存',
  `hidden` int(10) NOT NULL COMMENT '是否隐藏',
  `pid` int(11) NOT NULL COMMENT '所属一级',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='前端二级路由';

-- ----------------------------
-- Table structure for wy_standard
-- ----------------------------
DROP TABLE IF EXISTS `wy_standard`;
CREATE TABLE `wy_standard` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `type` tinyint(1) NOT NULL COMMENT '类型：1=周期性，2=临时性，3=押金性',
  `money_type` tinyint(1) NOT NULL COMMENT '计费精度：1=元，2=角，3=分',
  `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  `overdue_count` tinyint(1) DEFAULT NULL COMMENT '滞纳金计算时间：1=账单开始，2=账单结束',
  `days` int(10) DEFAULT NULL COMMENT '天数',
  `proportion` int(10) DEFAULT NULL COMMENT '比例（%）',
  `no_prices_set` tinyint(1) DEFAULT NULL COMMENT '当费用不足一个周期时设置：1=按周期计算，2=按实际天数计算',
  `open_loss` tinyint(1) DEFAULT NULL COMMENT '是否开始损耗：1=开启，2=不开启',
  `loss_count` tinyint(1) DEFAULT NULL COMMENT '损耗计算方式：1=固定值，2=百分比',
  `loss_values` int(10) DEFAULT NULL COMMENT '损耗计算值',
  `defaults_prices_set` tinyint(1) DEFAULT NULL COMMENT '默认收费周期设置：1=当期收档期，2=当期收上期，3=当期收下期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收费项目标准';

-- ----------------------------
-- Table structure for wy_table
-- ----------------------------
DROP TABLE IF EXISTS `wy_table`;
CREATE TABLE `wy_table` (
  `id` int(11) NOT NULL COMMENT 'id',
  `bd_info_id` int(11) NOT NULL COMMENT '所属小区',
  `houses_id` int(11) NOT NULL COMMENT '所属房屋',
  `project_text` varchar(255) NOT NULL COMMENT '收费项目',
  `standard_id` int(11) NOT NULL COMMENT '收费标准',
  `createtime` datetime NOT NULL COMMENT '开始时间',
  `endtime` datetime NOT NULL COMMENT '结束时间',
  `price` decimal(10,2) NOT NULL COMMENT '单价',
  `start_degree` decimal(10,4) NOT NULL DEFAULT '0.0000' COMMENT '起度',
  `end_degree` decimal(10,4) NOT NULL DEFAULT '0.0000' COMMENT '止度',
  `double` decimal(10,2) NOT NULL DEFAULT '1.00' COMMENT '倍率',
  `public` decimal(10,3) NOT NULL DEFAULT '0.000' COMMENT '公摊',
  `deplete` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '损耗',
  `use` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '用量',
  `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='抄表数据';

-- ----------------------------
-- Table structure for wy_unit
-- ----------------------------
DROP TABLE IF EXISTS `wy_unit`;
CREATE TABLE `wy_unit` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) NOT NULL COMMENT '单元名称',
  `bd_info_id` int(11) NOT NULL COMMENT '所属小区',
  `building_id` int(11) NOT NULL COMMENT '所属楼宇',
  `houses_number` int(10) NOT NULL COMMENT '房屋数量',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='单元';

SET FOREIGN_KEY_CHECKS = 1;
